CHRIST (Deemed to University), Bangalore

DEPARTMENT OF COMPUTER SCIENCE

School of Sciences






Syllabus for
BCA /(Honours/Honours with Research)
Academic Year  (2024)

 
        

  

Assesment Pattern

 

         

ESE-50%

CIA-50%

Examination And Assesments

1.      Evaluation Pattern: 50% CIA + 50% ESE

2.      Tutorials / Assignments / Tests / Quiz / Seminar.

3.      Attendance is part of the CIA component.

4.      Minimum percentage to pass in each paper is 50% (CIA + ESE).

Department Overview:

The department was established in the year 1990, with a  curriculum in line with industry expectations and research. The department also provides opportunities to work on collaborative projects with industry and international universities, faculty expertise in recent technologies and Alumni support are some of the department highlights. The following programmes are offered by the department;

Undergraduate Programmes
BSc CM-Bachelor of Science (BSc) in Computer Sc, Mathematics / Honours / Honours with Research
BSc CS-Bachelor of Science (BSc) in Computer Sc, Statistics / Honours / Honours with Research
BCA-Bachelor of Computer Applications (BCA) / Honours / Honours with Research

BSc CME-Bachelor of Science (BSc) in Computer Sc, Maths, Electronics
BSc CMS-Bachelor of Science (BSc) in Computer Sc, Maths, Statistics

Postgraduate Programmes

Master of Science (Artificial Intelligence and Machine Learning)
Master of Computer Applications (MCA)
Master of Science (Computer Science and Applications)

Research Programmes
Doctor of Philosophy (PhD) in Computer Science

Mission Statement:

VISION

 

The Department of Computer Science endeavors to imbibe the vision of the University “Excellence and Service”. The department is committed to this philosophy which pervades every aspect and functioning of the department.

MISSION

 

 

“To develop IT professionals with ethical and human values”. To accomplish our mission, the department encourages students to apply their acquired knowledge and skills towards professional achievements in their careers. The department also molds the students to be socially responsible and ethically sound.

Introduction to Program:

Bachelor of Computer Applications (BCA) is an undergraduate program that focuses on building software professionals with strong practical and theoretical knowledge in Computer Science. The curriculum provides options for students to choose multiple electives depending on their interest of study. Interdisciplinary Courses on Mathematics, Statistics and Financial management enhance the breadth of domain knowledge.

The program is backed by a well-motivated set of teachers and an upgraded lab facility. Students get opportunities to be part of in-house projects/research projects/consultancy projects. The sixth semester project would be a capstone project with deliverables in the form of a project/article/patent.

Students with good academic records are encouraged to take up a fast track so that they can go for a fulltime industry internship during the sixth semester. Ample opportunities with credit transfers are available for students who would like to go on a student exchange to foreign universities for a short semester.

The exit options after the first year with a certificate on “Basic Programming Skills” and the second year with a diploma in “Computer Applications” and a BCA degree after the third year, the program offers a fourth year with a BCA Honours degree with Research as on option is designed for better employment as either as an application developer or developer with research capabilities.

Program Objective:

Programme Outcome/Programme Learning Goals/Programme Learning Outcome:

PO1: Acquire and Apply Knowledge: Ability to understand and apply the fundamental principles, concepts and methods in key areas of Computer Applications and multidisciplinary fields.

PO2: Problem Analysis: Ability to analyze real-time problems using various tools and techniques.

PO3: Design and Development: Ability to design and develop solutions to meet the desired needs.

PO4: State-of-art Technologies: Ability to adapt and apply emerging tools and technologies.

PO5: Entrepreneurship and Innovation: Ability to provide sustainable and innovative solutions for real-time problems.

PO6: Lifelong Learning: Ability to engage in continuous reflective learning in the context of technological advancement.

PO7: Communication and Team Building: Ability to demonstrate effective communication and interpersonal skills.

PO8: Ethics and Social Responsibility: Ability to integrate ethical and human values to become a socially responsible citizen.

Programme Specific Outcome:

NA: NA

Programme Educational Objective:

NA: NA

BCA101-1 - FOUNDATIONAL MATHEMATICS (2024 Batch)

Total Teaching Hours for Semester:45
No of Lecture Hours/Week:3
Max Marks:75
Credits:3

Course Objectives/Course Description

 

 

This course aims at introducing the students to the world of Discrete Mathematics. It includes topics like Mathematical Logic, Method of proofs, Mathematical induction, Permutations and combinations and Binomial coefficients. Also, this course emphasizes general techniques of problem-solving and explores the creation of mathematical patterns.

 This course will help the learner to

CO1. Understand and use the notions of mathematical logic.

CO2. Give proofs for mathematical problems by using different methods of proofs. 

CO3. Prove the mathematical problems/statements by using mathematical induction. 

CO4. Use the permutations, combinations, and binomial coefficients for solving problems.

 

Learning Outcome

CO1: Reformulate statements from common language to formal logic using the rules of propositional and predicate calculus and assess the validity of arguments.

CO2: formulate and interpret statements presented and determine their validity by applying the rules and methods of propositional logic.

CO3: construct elementary proofs using ordinary and strong induction in the context of studying the properties of recursion.

CO4: apply basic counting principles including the pigeonhole principle and rules for counting permutations and combinations.

CO5: apply the logical structure of proofs and work symbolically with connectives and quantifiers to produce logically valid, correct and clear arguments

Unit-1
Teaching Hours:20
PROPOSITIONAL LOGIC, PREDICATES AND QUANTIFIERS
 

Propositional Logic, Applications of Propositional Logic, Propositional Equivalences, Predicates and Quantifiers, Nested Quantifiers, Rules of Inference.

 

Unit-1
Teaching Hours:20
PROPOSITIONAL LOGIC, PREDICATES AND QUANTIFIERS
 

Propositional Logic, Applications of Propositional Logic, Propositional Equivalences, Predicates and Quantifiers, Nested Quantifiers, Rules of Inference.

 

Unit-1
Teaching Hours:20
PROPOSITIONAL LOGIC, PREDICATES AND QUANTIFIERS
 

Propositional Logic, Applications of Propositional Logic, Propositional Equivalences, Predicates and Quantifiers, Nested Quantifiers, Rules of Inference.

 

Unit-1
Teaching Hours:20
PROPOSITIONAL LOGIC, PREDICATES AND QUANTIFIERS
 

Propositional Logic, Applications of Propositional Logic, Propositional Equivalences, Predicates and Quantifiers, Nested Quantifiers, Rules of Inference.

 

Unit-2
Teaching Hours:10
RULES OF INFERENCE AND PROOF METHODS
 

 

Introduction to Proofs, Proof Methods and Strategy.

Unit-2
Teaching Hours:10
RULES OF INFERENCE AND PROOF METHODS
 

 

Introduction to Proofs, Proof Methods and Strategy.

Unit-2
Teaching Hours:10
RULES OF INFERENCE AND PROOF METHODS
 

 

Introduction to Proofs, Proof Methods and Strategy.

Unit-2
Teaching Hours:10
RULES OF INFERENCE AND PROOF METHODS
 

 

Introduction to Proofs, Proof Methods and Strategy.

Unit-3
Teaching Hours:15
MATHEMETICAL INDUCTION AND COUNTING
 

Mathematical Induction, The Basics of Counting, The Pigeonhole Principle, Permutations and Combinations, Binomial Coefficients and Identities.

 

Unit-3
Teaching Hours:15
MATHEMETICAL INDUCTION AND COUNTING
 

Mathematical Induction, The Basics of Counting, The Pigeonhole Principle, Permutations and Combinations, Binomial Coefficients and Identities.

 

Unit-3
Teaching Hours:15
MATHEMETICAL INDUCTION AND COUNTING
 

Mathematical Induction, The Basics of Counting, The Pigeonhole Principle, Permutations and Combinations, Binomial Coefficients and Identities.

 

Unit-3
Teaching Hours:15
MATHEMETICAL INDUCTION AND COUNTING
 

Mathematical Induction, The Basics of Counting, The Pigeonhole Principle, Permutations and Combinations, Binomial Coefficients and Identities.

 

Text Books And Reference Books:

1. K. H. Rosen, Discrete Mathematics and its Applications, 7th ed., McGraw – Hill, 2012.

Essential Reading / Recommended Reading
  1. R.P. Grimaldi and B.V. Ramana, Discrete and Combinatorial Mathematics, An applied introduction, 5th ed., Pearson Education, 2007.

  2. D. S. Chandrasekharaiah, Discrete Mathematical Structures, 4th ed., India: PRISM Book Pvt. Ltd., 2012.

  3. J. P. Tremblay and R. Manohar, Discrete Mathematical Structures with Application to Computer Science, Reprint, India: Tata McGraw Hill Education, 2008.

 

Evaluation Pattern

ESE - 50%

CIA - 50%

BCA102-1 - OBJECT ORIENTED PROGRAMMING USING C++ (2024 Batch)

Total Teaching Hours for Semester:90
No of Lecture Hours/Week:6
Max Marks:100
Credits:4

Course Objectives/Course Description

 

The concept of classes and objects make it easy to represent real world entities. The subject starts with the comparison between procedural languages and object languages. The concepts of operator overloading and function overloading, files, exceptions are discussed to expose the students to the advantages of object-oriented programming. 

 

  • To make student familiar with OOPS concepts

  • To teach programming in C++ 

  • To understand the difference between object oriented and procedure-oriented programming.

Learning Outcome

CO1: Introduces Object Oriented Programming concepts using the C++ language

CO2: Understanding the principles of Classes and Objects, data abstraction, inheritance and polymorphism

CO3: Apply the principles of virtual functions

CO4: Analyzing the handling formatted I/O and unformatted

Unit-1
Teaching Hours:18
CLASSES AND OBJECTS
 

Introduction - Defining a Class - Creating objects -Accessing class members-Defining member functions-Outside the class definition-Inside the class definition-Outside functions as inline-Nesting of member functions-Private member functions-Memory allocation for objects-Array of objects. Friend functions.  

 

Lab Exercises:

 

  1. Implementation of classes and objects.

  2. Implementation of function overloading.

  3. Implementation of default arguments.

  4. Implementation of pass by value, pass by reference and return by reference.

Constructors and destructors 

Basic Concepts of Constructors-Default Constructor-Parameterized Constructor-Multiple constructors in a Class-Constructor with default Arguments-Dynamic initialization of Objects-Copy Constructor-Dynamic Constructors-Destructors.

 

Lab Exercises:

 

  1. Implementation of default, copy constructors

  2. Implementation of constructor overloading.

  3. Implementation of static functions. 

  4. Implementation of friend functions. 

Unit-1
Teaching Hours:18
FUNCTION AND OPERATOR OVERLOADING
 

Overloading Concepts Function Overloading: Functions with different sets of parameters, default and constant parameters. Rules for overloading Operators-Defining Operator Overloading-Overloading Unary Operators-Prefix and Postfix Operators Overloading-Overloading Binary Operators-Overloading Relational Operators-Overloading using friend Functions-Overloading subscript operator. 

Lab Exercises:-

 

  1. Implementation of Unary operator overloading. 

  2. Implementation of Binary operator overloading. 

  3. Implementation of subscript operator overloading. 

  4. Implementation of dynamic memory allocation and deallocation new and delete using constructors and destructors. 

Unit-1
Teaching Hours:18
INTRODUCTION TO C PROGRAMMING
 

Data type Declaration.  The Decision Control Structure - The if - if-else- Nested if-else statements. Decisions Using switch - The Loop Control Structure While Loop - for Loop - break Statement - continue Statement- do-while Loop.  Arrays and Structures.

Unit-1
Teaching Hours:18
STREAMS
 

C++ stream classes-put and get functions-getline and write functions-Overloading << and >> operators-Formatted Console I/O operations-ios class functions-width, precision, fill, setf and unsetf-Formatting flags-Manipulators-User defined manipulators.  Introduction to files in C++.

 

Self Learning

 

Put, get, width, precision

 

Unit-1
Teaching Hours:18
INHERITANCE
 

Introduction-Defining derived classes-Types of inheritances-Single-Making a private member inheritable-Multilevel inheritance-Multiple inheritance-Hierarchical inheritance-Hybrid inheritance-Virtual base classes-Abstract classes-Constructors in derived classes. 

 

Virtual functions and run time polymorphism-Introduction-Compile time and Runtime polymorphism-Pointers to objects-this pointer-Pointer to derived classes-Virtual functions-Rules for virtual functions-Pure virtual functions. 

 

Self-Learning

Hybrid inheritance

 

Lab Exercises:-

 

  1. Implementation of simple and multi-level inheritance. 

  2. Implementation of multiple inheritance and hybrid inheritance. 

  3. Implementation of virtual functions.

Unit-1
Teaching Hours:18
CLASSES AND OBJECTS
 

Introduction - Defining a Class - Creating objects -Accessing class members-Defining member functions-Outside the class definition-Inside the class definition-Outside functions as inline-Nesting of member functions-Private member functions-Memory allocation for objects-Array of objects. Friend functions.  

 

Lab Exercises:

 

  1. Implementation of classes and objects.

  2. Implementation of function overloading.

  3. Implementation of default arguments.

  4. Implementation of pass by value, pass by reference and return by reference.

Constructors and destructors 

Basic Concepts of Constructors-Default Constructor-Parameterized Constructor-Multiple constructors in a Class-Constructor with default Arguments-Dynamic initialization of Objects-Copy Constructor-Dynamic Constructors-Destructors.

 

Lab Exercises:

 

  1. Implementation of default, copy constructors

  2. Implementation of constructor overloading.

  3. Implementation of static functions. 

  4. Implementation of friend functions. 

Unit-1
Teaching Hours:18
FUNCTION AND OPERATOR OVERLOADING
 

Overloading Concepts Function Overloading: Functions with different sets of parameters, default and constant parameters. Rules for overloading Operators-Defining Operator Overloading-Overloading Unary Operators-Prefix and Postfix Operators Overloading-Overloading Binary Operators-Overloading Relational Operators-Overloading using friend Functions-Overloading subscript operator. 

Lab Exercises:-

 

  1. Implementation of Unary operator overloading. 

  2. Implementation of Binary operator overloading. 

  3. Implementation of subscript operator overloading. 

  4. Implementation of dynamic memory allocation and deallocation new and delete using constructors and destructors. 

Unit-1
Teaching Hours:18
INTRODUCTION TO C PROGRAMMING
 

Data type Declaration.  The Decision Control Structure - The if - if-else- Nested if-else statements. Decisions Using switch - The Loop Control Structure While Loop - for Loop - break Statement - continue Statement- do-while Loop.  Arrays and Structures.

Unit-1
Teaching Hours:18
STREAMS
 

C++ stream classes-put and get functions-getline and write functions-Overloading << and >> operators-Formatted Console I/O operations-ios class functions-width, precision, fill, setf and unsetf-Formatting flags-Manipulators-User defined manipulators.  Introduction to files in C++.

 

Self Learning

 

Put, get, width, precision

 

Unit-1
Teaching Hours:18
INHERITANCE
 

Introduction-Defining derived classes-Types of inheritances-Single-Making a private member inheritable-Multilevel inheritance-Multiple inheritance-Hierarchical inheritance-Hybrid inheritance-Virtual base classes-Abstract classes-Constructors in derived classes. 

 

Virtual functions and run time polymorphism-Introduction-Compile time and Runtime polymorphism-Pointers to objects-this pointer-Pointer to derived classes-Virtual functions-Rules for virtual functions-Pure virtual functions. 

 

Self-Learning

Hybrid inheritance

 

Lab Exercises:-

 

  1. Implementation of simple and multi-level inheritance. 

  2. Implementation of multiple inheritance and hybrid inheritance. 

  3. Implementation of virtual functions.

Unit-1
Teaching Hours:18
CLASSES AND OBJECTS
 

Introduction - Defining a Class - Creating objects -Accessing class members-Defining member functions-Outside the class definition-Inside the class definition-Outside functions as inline-Nesting of member functions-Private member functions-Memory allocation for objects-Array of objects. Friend functions.  

 

Lab Exercises:

 

  1. Implementation of classes and objects.

  2. Implementation of function overloading.

  3. Implementation of default arguments.

  4. Implementation of pass by value, pass by reference and return by reference.

Constructors and destructors 

Basic Concepts of Constructors-Default Constructor-Parameterized Constructor-Multiple constructors in a Class-Constructor with default Arguments-Dynamic initialization of Objects-Copy Constructor-Dynamic Constructors-Destructors.

 

Lab Exercises:

 

  1. Implementation of default, copy constructors

  2. Implementation of constructor overloading.

  3. Implementation of static functions. 

  4. Implementation of friend functions. 

Unit-1
Teaching Hours:18
FUNCTION AND OPERATOR OVERLOADING
 

Overloading Concepts Function Overloading: Functions with different sets of parameters, default and constant parameters. Rules for overloading Operators-Defining Operator Overloading-Overloading Unary Operators-Prefix and Postfix Operators Overloading-Overloading Binary Operators-Overloading Relational Operators-Overloading using friend Functions-Overloading subscript operator. 

Lab Exercises:-

 

  1. Implementation of Unary operator overloading. 

  2. Implementation of Binary operator overloading. 

  3. Implementation of subscript operator overloading. 

  4. Implementation of dynamic memory allocation and deallocation new and delete using constructors and destructors. 

Unit-1
Teaching Hours:18
INTRODUCTION TO C PROGRAMMING
 

Data type Declaration.  The Decision Control Structure - The if - if-else- Nested if-else statements. Decisions Using switch - The Loop Control Structure While Loop - for Loop - break Statement - continue Statement- do-while Loop.  Arrays and Structures.

Unit-1
Teaching Hours:18
STREAMS
 

C++ stream classes-put and get functions-getline and write functions-Overloading << and >> operators-Formatted Console I/O operations-ios class functions-width, precision, fill, setf and unsetf-Formatting flags-Manipulators-User defined manipulators.  Introduction to files in C++.

 

Self Learning

 

Put, get, width, precision

 

Unit-1
Teaching Hours:18
INHERITANCE
 

Introduction-Defining derived classes-Types of inheritances-Single-Making a private member inheritable-Multilevel inheritance-Multiple inheritance-Hierarchical inheritance-Hybrid inheritance-Virtual base classes-Abstract classes-Constructors in derived classes. 

 

Virtual functions and run time polymorphism-Introduction-Compile time and Runtime polymorphism-Pointers to objects-this pointer-Pointer to derived classes-Virtual functions-Rules for virtual functions-Pure virtual functions. 

 

Self-Learning

Hybrid inheritance

 

Lab Exercises:-

 

  1. Implementation of simple and multi-level inheritance. 

  2. Implementation of multiple inheritance and hybrid inheritance. 

  3. Implementation of virtual functions.

Unit-1
Teaching Hours:18
CLASSES AND OBJECTS
 

Introduction - Defining a Class - Creating objects -Accessing class members-Defining member functions-Outside the class definition-Inside the class definition-Outside functions as inline-Nesting of member functions-Private member functions-Memory allocation for objects-Array of objects. Friend functions.  

 

Lab Exercises:

 

  1. Implementation of classes and objects.

  2. Implementation of function overloading.

  3. Implementation of default arguments.

  4. Implementation of pass by value, pass by reference and return by reference.

Constructors and destructors 

Basic Concepts of Constructors-Default Constructor-Parameterized Constructor-Multiple constructors in a Class-Constructor with default Arguments-Dynamic initialization of Objects-Copy Constructor-Dynamic Constructors-Destructors.

 

Lab Exercises:

 

  1. Implementation of default, copy constructors

  2. Implementation of constructor overloading.

  3. Implementation of static functions. 

  4. Implementation of friend functions. 

Unit-1
Teaching Hours:18
FUNCTION AND OPERATOR OVERLOADING
 

Overloading Concepts Function Overloading: Functions with different sets of parameters, default and constant parameters. Rules for overloading Operators-Defining Operator Overloading-Overloading Unary Operators-Prefix and Postfix Operators Overloading-Overloading Binary Operators-Overloading Relational Operators-Overloading using friend Functions-Overloading subscript operator. 

Lab Exercises:-

 

  1. Implementation of Unary operator overloading. 

  2. Implementation of Binary operator overloading. 

  3. Implementation of subscript operator overloading. 

  4. Implementation of dynamic memory allocation and deallocation new and delete using constructors and destructors. 

Unit-1
Teaching Hours:18
INTRODUCTION TO C PROGRAMMING
 

Data type Declaration.  The Decision Control Structure - The if - if-else- Nested if-else statements. Decisions Using switch - The Loop Control Structure While Loop - for Loop - break Statement - continue Statement- do-while Loop.  Arrays and Structures.

Unit-1
Teaching Hours:18
STREAMS
 

C++ stream classes-put and get functions-getline and write functions-Overloading << and >> operators-Formatted Console I/O operations-ios class functions-width, precision, fill, setf and unsetf-Formatting flags-Manipulators-User defined manipulators.  Introduction to files in C++.

 

Self Learning

 

Put, get, width, precision

 

Unit-1
Teaching Hours:18
INHERITANCE
 

Introduction-Defining derived classes-Types of inheritances-Single-Making a private member inheritable-Multilevel inheritance-Multiple inheritance-Hierarchical inheritance-Hybrid inheritance-Virtual base classes-Abstract classes-Constructors in derived classes. 

 

Virtual functions and run time polymorphism-Introduction-Compile time and Runtime polymorphism-Pointers to objects-this pointer-Pointer to derived classes-Virtual functions-Rules for virtual functions-Pure virtual functions. 

 

Self-Learning

Hybrid inheritance

 

Lab Exercises:-

 

  1. Implementation of simple and multi-level inheritance. 

  2. Implementation of multiple inheritance and hybrid inheritance. 

  3. Implementation of virtual functions.

Text Books And Reference Books:

[1] Schildt Herbert, The Complete Reference C++, Tata McGraw Hill, Reprint, 2018.

Essential Reading / Recommended Reading

[1] Deitel&Deitel, C++ How to program, Pearson Education Asia, 6th Edition, 2016. 

[2] Bjarne Stroustrup, The C++ Programming Language, Special Edition, Pearson Education, 2018. 

[3] M. T. Somashekara, D. S. Guru, Object-Oriented Programming with C++, 2ndEdition, PHI, 2018.

Evaluation Pattern

ESE 50%

CIA 50%

BCA103-1 - PRINCIPLES OF SOFTWARE DEVELOPMENT - I (2024 Batch)

Total Teaching Hours for Semester:90
No of Lecture Hours/Week:6
Max Marks:150
Credits:5

Course Objectives/Course Description

 

This course is an introduction to software development principles, process and design. And this course provides strong foundation of database concepts  and develop   skills   for   the   design   and implementation  of  a  database  application.

 

Learning Outcome

CO1: Design and Develop ethical software product.

CO2: Apply terms, concepts, and tools of relational database management systems.

CO3: Construct database projects using DDL and DML queries.

Unit-1
Teaching Hours:18
SOFTWARE AND SOFTWARE ENGINEERING
 

Nature of software- Defining software, Software Application Domains, Legacy Software - Software Engineering, The software process, Software Engineering practice – The essence of Practice, General Principles - Software Myths.

Database Management System - Introduction

Data, Database, Database management system, Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Advantages of Using a DBMS and When not to use a DBMS. Introduction to RDBMS.

Lab Exercises:

1. Introduction: logging on to SQL interface, exploring the system dummy tables

2. Perform basic DDL commands

 

Unit-1
Teaching Hours:18
SOFTWARE AND SOFTWARE ENGINEERING
 

Nature of software- Defining software, Software Application Domains, Legacy Software - Software Engineering, The software process, Software Engineering practice – The essence of Practice, General Principles - Software Myths.

Database Management System - Introduction

Data, Database, Database management system, Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Advantages of Using a DBMS and When not to use a DBMS. Introduction to RDBMS.

Lab Exercises:

1. Introduction: logging on to SQL interface, exploring the system dummy tables

2. Perform basic DDL commands

 

Unit-1
Teaching Hours:18
SOFTWARE AND SOFTWARE ENGINEERING
 

Nature of software- Defining software, Software Application Domains, Legacy Software - Software Engineering, The software process, Software Engineering practice – The essence of Practice, General Principles - Software Myths.

Database Management System - Introduction

Data, Database, Database management system, Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Advantages of Using a DBMS and When not to use a DBMS. Introduction to RDBMS.

Lab Exercises:

1. Introduction: logging on to SQL interface, exploring the system dummy tables

2. Perform basic DDL commands

 

Unit-1
Teaching Hours:18
SOFTWARE AND SOFTWARE ENGINEERING
 

Nature of software- Defining software, Software Application Domains, Legacy Software - Software Engineering, The software process, Software Engineering practice – The essence of Practice, General Principles - Software Myths.

Database Management System - Introduction

Data, Database, Database management system, Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Advantages of Using a DBMS and When not to use a DBMS. Introduction to RDBMS.

Lab Exercises:

1. Introduction: logging on to SQL interface, exploring the system dummy tables

2. Perform basic DDL commands

 

Unit-2
Teaching Hours:18
PROCESS MODELS
 

A generic process model – Defining a framework activity, identifying a Task Set, Process Patterns - Process Assessment and improvement, Prescriptive Process Models – The waterfall Model, Incremental Model, Evolutionary Process Model, Concurrent Models- A Final Word on Evolutionary Processes.

SQL

SQL data definition and data types, specifying constraints in SQL, schema update statements, Basic queries, INSERT, DELETE and UPDATE statements in SQL.

Lab Exercises: 

1. Perform various DML queries in databases.

2. Perform complex DDL, DML queries with where clause and violations.

Unit-2
Teaching Hours:18
PROCESS MODELS
 

A generic process model – Defining a framework activity, identifying a Task Set, Process Patterns - Process Assessment and improvement, Prescriptive Process Models – The waterfall Model, Incremental Model, Evolutionary Process Model, Concurrent Models- A Final Word on Evolutionary Processes.

SQL

SQL data definition and data types, specifying constraints in SQL, schema update statements, Basic queries, INSERT, DELETE and UPDATE statements in SQL.

Lab Exercises: 

1. Perform various DML queries in databases.

2. Perform complex DDL, DML queries with where clause and violations.

Unit-2
Teaching Hours:18
PROCESS MODELS
 

A generic process model – Defining a framework activity, identifying a Task Set, Process Patterns - Process Assessment and improvement, Prescriptive Process Models – The waterfall Model, Incremental Model, Evolutionary Process Model, Concurrent Models- A Final Word on Evolutionary Processes.

SQL

SQL data definition and data types, specifying constraints in SQL, schema update statements, Basic queries, INSERT, DELETE and UPDATE statements in SQL.

Lab Exercises: 

1. Perform various DML queries in databases.

2. Perform complex DDL, DML queries with where clause and violations.

Unit-2
Teaching Hours:18
PROCESS MODELS
 

A generic process model – Defining a framework activity, identifying a Task Set, Process Patterns - Process Assessment and improvement, Prescriptive Process Models – The waterfall Model, Incremental Model, Evolutionary Process Model, Concurrent Models- A Final Word on Evolutionary Processes.

SQL

SQL data definition and data types, specifying constraints in SQL, schema update statements, Basic queries, INSERT, DELETE and UPDATE statements in SQL.

Lab Exercises: 

1. Perform various DML queries in databases.

2. Perform complex DDL, DML queries with where clause and violations.

Unit-3
Teaching Hours:18
UNDERSTSNDING REQUIREMENTS
 

Requirements Engineering, Establishing the groundwork – Identifying Stakeholders, Recognizing multiple viewpoints, Working toward Collaboration, Asking the first questions-, Eliciting requirements – Collaborative requirement gathering, Quality function Deployment, Usage Scenario Elicitation Work Products - Developing use cases, building the requirements model – Elements of the requirements Model, Analysis pattern - Negotiating requirements, validating requirements.

Relational Data Model

Relation, Integrity constraints - domain, entity and Referential integrity constraints: unique, not null, check, Primary Key, Foreign key.

Lab Exercises: 

1. Apply Integrity constraints using create and modify clauses.

2. Violate each integrity constraint and show the system violation errors.

Unit-3
Teaching Hours:18
UNDERSTSNDING REQUIREMENTS
 

Requirements Engineering, Establishing the groundwork – Identifying Stakeholders, Recognizing multiple viewpoints, Working toward Collaboration, Asking the first questions-, Eliciting requirements – Collaborative requirement gathering, Quality function Deployment, Usage Scenario Elicitation Work Products - Developing use cases, building the requirements model – Elements of the requirements Model, Analysis pattern - Negotiating requirements, validating requirements.

Relational Data Model

Relation, Integrity constraints - domain, entity and Referential integrity constraints: unique, not null, check, Primary Key, Foreign key.

Lab Exercises: 

1. Apply Integrity constraints using create and modify clauses.

2. Violate each integrity constraint and show the system violation errors.

Unit-3
Teaching Hours:18
UNDERSTSNDING REQUIREMENTS
 

Requirements Engineering, Establishing the groundwork – Identifying Stakeholders, Recognizing multiple viewpoints, Working toward Collaboration, Asking the first questions-, Eliciting requirements – Collaborative requirement gathering, Quality function Deployment, Usage Scenario Elicitation Work Products - Developing use cases, building the requirements model – Elements of the requirements Model, Analysis pattern - Negotiating requirements, validating requirements.

Relational Data Model

Relation, Integrity constraints - domain, entity and Referential integrity constraints: unique, not null, check, Primary Key, Foreign key.

Lab Exercises: 

1. Apply Integrity constraints using create and modify clauses.

2. Violate each integrity constraint and show the system violation errors.

Unit-3
Teaching Hours:18
UNDERSTSNDING REQUIREMENTS
 

Requirements Engineering, Establishing the groundwork – Identifying Stakeholders, Recognizing multiple viewpoints, Working toward Collaboration, Asking the first questions-, Eliciting requirements – Collaborative requirement gathering, Quality function Deployment, Usage Scenario Elicitation Work Products - Developing use cases, building the requirements model – Elements of the requirements Model, Analysis pattern - Negotiating requirements, validating requirements.

Relational Data Model

Relation, Integrity constraints - domain, entity and Referential integrity constraints: unique, not null, check, Primary Key, Foreign key.

Lab Exercises: 

1. Apply Integrity constraints using create and modify clauses.

2. Violate each integrity constraint and show the system violation errors.

Unit-4
Teaching Hours:18
DESIGN CONCEPTS
 

The design within the context of Software Engineering, The design process – Software quality guidelines and attributes, The evolution of software design - Design concepts – Abstraction, Architecture, Patterns, Separation of concerns, Modularity, information hiding, Functional Independence, refinement, Aspects, Refactoring, Object Oriented design concepts Design classes - The design Model – Data Design elements, Architectural Design elements, Interface Design Elements, Component-Level Design elements, Deployment level Design elements.

SQL

Views, Sub queries and correlated queries.

Lab Exercises:

1. Implement create, delete and update operations of views.

1. Implement Sub queries.

Unit-4
Teaching Hours:18
DESIGN CONCEPTS
 

The design within the context of Software Engineering, The design process – Software quality guidelines and attributes, The evolution of software design - Design concepts – Abstraction, Architecture, Patterns, Separation of concerns, Modularity, information hiding, Functional Independence, refinement, Aspects, Refactoring, Object Oriented design concepts Design classes - The design Model – Data Design elements, Architectural Design elements, Interface Design Elements, Component-Level Design elements, Deployment level Design elements.

SQL

Views, Sub queries and correlated queries.

Lab Exercises:

1. Implement create, delete and update operations of views.

1. Implement Sub queries.

Unit-4
Teaching Hours:18
DESIGN CONCEPTS
 

The design within the context of Software Engineering, The design process – Software quality guidelines and attributes, The evolution of software design - Design concepts – Abstraction, Architecture, Patterns, Separation of concerns, Modularity, information hiding, Functional Independence, refinement, Aspects, Refactoring, Object Oriented design concepts Design classes - The design Model – Data Design elements, Architectural Design elements, Interface Design Elements, Component-Level Design elements, Deployment level Design elements.

SQL

Views, Sub queries and correlated queries.

Lab Exercises:

1. Implement create, delete and update operations of views.

1. Implement Sub queries.

Unit-4
Teaching Hours:18
DESIGN CONCEPTS
 

The design within the context of Software Engineering, The design process – Software quality guidelines and attributes, The evolution of software design - Design concepts – Abstraction, Architecture, Patterns, Separation of concerns, Modularity, information hiding, Functional Independence, refinement, Aspects, Refactoring, Object Oriented design concepts Design classes - The design Model – Data Design elements, Architectural Design elements, Interface Design Elements, Component-Level Design elements, Deployment level Design elements.

SQL

Views, Sub queries and correlated queries.

Lab Exercises:

1. Implement create, delete and update operations of views.

1. Implement Sub queries.

Unit-5
Teaching Hours:18
SOFTWARE TESTING STRATEGIES
 

A strategic approach to Software Testing – Strategic Issues – Validation Testing – System Testing – The Art of Debugging.

Data Modeling Using Entity-Relationship Model

Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Roles and Structural constraints. Weak Entity Types and Drawing E- R Diagrams.

Lab Exercise:

9. Design relation models (from the chosen domain)

Unit-5
Teaching Hours:18
SOFTWARE TESTING STRATEGIES
 

A strategic approach to Software Testing – Strategic Issues – Validation Testing – System Testing – The Art of Debugging.

Data Modeling Using Entity-Relationship Model

Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Roles and Structural constraints. Weak Entity Types and Drawing E- R Diagrams.

Lab Exercise:

9. Design relation models (from the chosen domain)

Unit-5
Teaching Hours:18
SOFTWARE TESTING STRATEGIES
 

A strategic approach to Software Testing – Strategic Issues – Validation Testing – System Testing – The Art of Debugging.

Data Modeling Using Entity-Relationship Model

Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Roles and Structural constraints. Weak Entity Types and Drawing E- R Diagrams.

Lab Exercise:

9. Design relation models (from the chosen domain)

Unit-5
Teaching Hours:18
SOFTWARE TESTING STRATEGIES
 

A strategic approach to Software Testing – Strategic Issues – Validation Testing – System Testing – The Art of Debugging.

Data Modeling Using Entity-Relationship Model

Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Roles and Structural constraints. Weak Entity Types and Drawing E- R Diagrams.

Lab Exercise:

9. Design relation models (from the chosen domain)

Text Books And Reference Books:

[1]Software Engineering, Sommerville, Ian Addison Wesley, 9th Edition, 2010.

[2] Object Oriented Modeling and design, Rumbaugh, James, , Pearson Education, New Delhi, 2005.

[3] Database System Concepts, Silberschatz, Korth, Sudarshan, 5 Edition, McGraw Hill, 2006.

[4] Database Principles, Programming and Performance, O`neil Patricand, O`neil Elizabeth, Margon Kaufmann Publishers Inc, 2nd Edition, 2008.

 [5] Database System Concepts, Silberschatz, Korth, Sudarshan, 5 Edition, McGraw Hill, 2006.

 

Essential Reading / Recommended Reading

[1] Software Engineering A Practitioner‟s Approach, Pressman S Roger McGraw Hill, International Editions, 7th edition, 2010.

 [2] Fundamentals of Database Systems, Elmasri Ramez and Navathe Shamkant B, Addison-Wesley, 6th Edition, 2010.

Evaluation Pattern

ESE - 30%

CIA - 70%

BCA161-1 - INTRODUCTION TO WEB TECHNOLOGY (2024 Batch)

Total Teaching Hours for Semester:60
No of Lecture Hours/Week:4
Max Marks:100
Credits:3

Course Objectives/Course Description

 

Course Objectives

 

The objective of the course is to introduce the web page development technologies. In this course, students will be able to explore Hypertext Markup Language – its tags for content display and organization. CSS will be introduced for designing the web pages. PHP and MySQL will be introduced for Functionality and Database.

Learning Outcome

CO1: Identify basic elements of web page development with various layouts.

CO2: Understand HTML tags and CSS styles for website development

CO3: Apply knowledge of scripting in web development

CO4: Describe the major PHP basics and functionalities associated with webpage / web application development.

CO5: Explain the various operations of Database using MySQL used for webpage / web application development.

Unit-1
Teaching Hours:12
Hypertext Markup Language (HTML)
 

Hypertext Markup Language (HTML)

Introduction to HTML Basic tags and Web Navigation, HTML Header, HTML Elements, HTML Attributes, Formatting – Comments - Images – Tables – Lists: Ordered and Unordered Lists - Test Links - Image Links – Frames – Blocks – Backgrounds – Colors: Text color, Background color, Background color etc., – Fonts – Forms: Form elements – Embed multimedia – Marquees. Webpage layout.

Lab Exercises:

Program 01: Program to demonstrate HTML Header, Elements attributes and formatting

Program 02: Program to demonstrate Lists, Images, Background, Table and Forms

Unit-1
Teaching Hours:12
Hypertext Markup Language (HTML)
 

Hypertext Markup Language (HTML)

Introduction to HTML Basic tags and Web Navigation, HTML Header, HTML Elements, HTML Attributes, Formatting – Comments - Images – Tables – Lists: Ordered and Unordered Lists - Test Links - Image Links – Frames – Blocks – Backgrounds – Colors: Text color, Background color, Background color etc., – Fonts – Forms: Form elements – Embed multimedia – Marquees. Webpage layout.

Lab Exercises:

Program 01: Program to demonstrate HTML Header, Elements attributes and formatting

Program 02: Program to demonstrate Lists, Images, Background, Table and Forms

Unit-1
Teaching Hours:12
Hypertext Markup Language (HTML)
 

Hypertext Markup Language (HTML)

Introduction to HTML Basic tags and Web Navigation, HTML Header, HTML Elements, HTML Attributes, Formatting – Comments - Images – Tables – Lists: Ordered and Unordered Lists - Test Links - Image Links – Frames – Blocks – Backgrounds – Colors: Text color, Background color, Background color etc., – Fonts – Forms: Form elements – Embed multimedia – Marquees. Webpage layout.

Lab Exercises:

Program 01: Program to demonstrate HTML Header, Elements attributes and formatting

Program 02: Program to demonstrate Lists, Images, Background, Table and Forms

Unit-1
Teaching Hours:12
Hypertext Markup Language (HTML)
 

Hypertext Markup Language (HTML)

Introduction to HTML Basic tags and Web Navigation, HTML Header, HTML Elements, HTML Attributes, Formatting – Comments - Images – Tables – Lists: Ordered and Unordered Lists - Test Links - Image Links – Frames – Blocks – Backgrounds – Colors: Text color, Background color, Background color etc., – Fonts – Forms: Form elements – Embed multimedia – Marquees. Webpage layout.

Lab Exercises:

Program 01: Program to demonstrate HTML Header, Elements attributes and formatting

Program 02: Program to demonstrate Lists, Images, Background, Table and Forms

Unit-2
Teaching Hours:12
Cascading Style Sheet (CSS)
 

Cascading Style Sheet (CSS)

CSS Introduction – CSS Versions – Syntax – Inclusion – Measurement units – CSS Color scheme – CSS Backgrounds for webpage and layout – CSS Fonts – CSS Text – CSS Image and related styles – CSS Links – CSS Tables – CSS Borders – CSS Margins – CSS Lists – CSS Padding – Cursors – Scrollbars; Advanced CSS: Positioning and Text effects, Media inclusion and types.

Self-study: CSS Responsive Web Designing 

Lab Exercises:

Program 03: Program to demonstrate CSS color schemes, Text – Image – Links and table styles

Program 04: Program to demonstrate CSS lists, padding, and responsive designing.

Unit-2
Teaching Hours:12
Cascading Style Sheet (CSS)
 

Cascading Style Sheet (CSS)

CSS Introduction – CSS Versions – Syntax – Inclusion – Measurement units – CSS Color scheme – CSS Backgrounds for webpage and layout – CSS Fonts – CSS Text – CSS Image and related styles – CSS Links – CSS Tables – CSS Borders – CSS Margins – CSS Lists – CSS Padding – Cursors – Scrollbars; Advanced CSS: Positioning and Text effects, Media inclusion and types.

Self-study: CSS Responsive Web Designing 

Lab Exercises:

Program 03: Program to demonstrate CSS color schemes, Text – Image – Links and table styles

Program 04: Program to demonstrate CSS lists, padding, and responsive designing.

Unit-2
Teaching Hours:12
Cascading Style Sheet (CSS)
 

Cascading Style Sheet (CSS)

CSS Introduction – CSS Versions – Syntax – Inclusion – Measurement units – CSS Color scheme – CSS Backgrounds for webpage and layout – CSS Fonts – CSS Text – CSS Image and related styles – CSS Links – CSS Tables – CSS Borders – CSS Margins – CSS Lists – CSS Padding – Cursors – Scrollbars; Advanced CSS: Positioning and Text effects, Media inclusion and types.

Self-study: CSS Responsive Web Designing 

Lab Exercises:

Program 03: Program to demonstrate CSS color schemes, Text – Image – Links and table styles

Program 04: Program to demonstrate CSS lists, padding, and responsive designing.

Unit-2
Teaching Hours:12
Cascading Style Sheet (CSS)
 

Cascading Style Sheet (CSS)

CSS Introduction – CSS Versions – Syntax – Inclusion – Measurement units – CSS Color scheme – CSS Backgrounds for webpage and layout – CSS Fonts – CSS Text – CSS Image and related styles – CSS Links – CSS Tables – CSS Borders – CSS Margins – CSS Lists – CSS Padding – Cursors – Scrollbars; Advanced CSS: Positioning and Text effects, Media inclusion and types.

Self-study: CSS Responsive Web Designing 

Lab Exercises:

Program 03: Program to demonstrate CSS color schemes, Text – Image – Links and table styles

Program 04: Program to demonstrate CSS lists, padding, and responsive designing.

Unit-3
Teaching Hours:12
JAVA SCRIPT - FUNDAMENTALS
 

Java Script (JS Script) 

Introduction to Java Script (Jscript) – Installation – Syntax – Variables – Operators – If else – Switch case – Loop controls: for loop, do while loop; Functions – Events – Cookies – Page redirect – JavaScript Objects: Arrays, Date HTML DOM

 

Lab Exercises: 

Program 5. Program to demonstrate Jscript variables and operators

Program 6.Program to demonstrate loop controls – decision controls and functions

Unit-3
Teaching Hours:12
JAVA SCRIPT - FUNDAMENTALS
 

Java Script (JS Script) 

Introduction to Java Script (Jscript) – Installation – Syntax – Variables – Operators – If else – Switch case – Loop controls: for loop, do while loop; Functions – Events – Cookies – Page redirect – JavaScript Objects: Arrays, Date HTML DOM

 

Lab Exercises: 

Program 5. Program to demonstrate Jscript variables and operators

Program 6.Program to demonstrate loop controls – decision controls and functions

Unit-3
Teaching Hours:12
JAVA SCRIPT - FUNDAMENTALS
 

Java Script (JS Script) 

Introduction to Java Script (Jscript) – Installation – Syntax – Variables – Operators – If else – Switch case – Loop controls: for loop, do while loop; Functions – Events – Cookies – Page redirect – JavaScript Objects: Arrays, Date HTML DOM

 

Lab Exercises: 

Program 5. Program to demonstrate Jscript variables and operators

Program 6.Program to demonstrate loop controls – decision controls and functions

Unit-3
Teaching Hours:12
JAVA SCRIPT - FUNDAMENTALS
 

Java Script (JS Script) 

Introduction to Java Script (Jscript) – Installation – Syntax – Variables – Operators – If else – Switch case – Loop controls: for loop, do while loop; Functions – Events – Cookies – Page redirect – JavaScript Objects: Arrays, Date HTML DOM

 

Lab Exercises: 

Program 5. Program to demonstrate Jscript variables and operators

Program 6.Program to demonstrate loop controls – decision controls and functions

Unit-4
Teaching Hours:12
HYPERTEXT PREPROCESSOR (PHP)
 

PHP Introduction – Installation version information – Environment setup – Variable types – Constants – Operator Types – Decision Making – Loop controls : for, do while ; Arrays – Strings – Web concepts – GET and POST methods – Functions – Cookies 

 

Lab Exercises:

Program 7.Program to demonstrate PHP variable types – operators Decision and loop controls

Program 8.Program to demonstrate GET and POST methods

 

Unit-4
Teaching Hours:12
HYPERTEXT PREPROCESSOR (PHP)
 

PHP Introduction – Installation version information – Environment setup – Variable types – Constants – Operator Types – Decision Making – Loop controls : for, do while ; Arrays – Strings – Web concepts – GET and POST methods – Functions – Cookies 

 

Lab Exercises:

Program 7.Program to demonstrate PHP variable types – operators Decision and loop controls

Program 8.Program to demonstrate GET and POST methods

 

Unit-4
Teaching Hours:12
HYPERTEXT PREPROCESSOR (PHP)
 

PHP Introduction – Installation version information – Environment setup – Variable types – Constants – Operator Types – Decision Making – Loop controls : for, do while ; Arrays – Strings – Web concepts – GET and POST methods – Functions – Cookies 

 

Lab Exercises:

Program 7.Program to demonstrate PHP variable types – operators Decision and loop controls

Program 8.Program to demonstrate GET and POST methods

 

Unit-4
Teaching Hours:12
HYPERTEXT PREPROCESSOR (PHP)
 

PHP Introduction – Installation version information – Environment setup – Variable types – Constants – Operator Types – Decision Making – Loop controls : for, do while ; Arrays – Strings – Web concepts – GET and POST methods – Functions – Cookies 

 

Lab Exercises:

Program 7.Program to demonstrate PHP variable types – operators Decision and loop controls

Program 8.Program to demonstrate GET and POST methods

 

Unit-5
Teaching Hours:12
DATABASE CONNECTION WITH MySQL
 

Introduction to MySQL, Installation version information – Connecting to MySQL database – Create a database – Delete a database – Insert data into MySQL Database: tables – Retrieve database from the database: tables – Updating data into the existing tables – Deleting data from the existing MySQL tables

Lab Exercises:

Program 09: Program to demonstrate MySQL Database and Table creation and Insertion of data

 Program 10: Program to demonstrate Updating data into the existing tables

 

Unit-5
Teaching Hours:12
DATABASE CONNECTION WITH MySQL
 

Introduction to MySQL, Installation version information – Connecting to MySQL database – Create a database – Delete a database – Insert data into MySQL Database: tables – Retrieve database from the database: tables – Updating data into the existing tables – Deleting data from the existing MySQL tables

Lab Exercises:

Program 09: Program to demonstrate MySQL Database and Table creation and Insertion of data

 Program 10: Program to demonstrate Updating data into the existing tables

 

Unit-5
Teaching Hours:12
DATABASE CONNECTION WITH MySQL
 

Introduction to MySQL, Installation version information – Connecting to MySQL database – Create a database – Delete a database – Insert data into MySQL Database: tables – Retrieve database from the database: tables – Updating data into the existing tables – Deleting data from the existing MySQL tables

Lab Exercises:

Program 09: Program to demonstrate MySQL Database and Table creation and Insertion of data

 Program 10: Program to demonstrate Updating data into the existing tables

 

Unit-5
Teaching Hours:12
DATABASE CONNECTION WITH MySQL
 

Introduction to MySQL, Installation version information – Connecting to MySQL database – Create a database – Delete a database – Insert data into MySQL Database: tables – Retrieve database from the database: tables – Updating data into the existing tables – Deleting data from the existing MySQL tables

Lab Exercises:

Program 09: Program to demonstrate MySQL Database and Table creation and Insertion of data

 Program 10: Program to demonstrate Updating data into the existing tables

 

Text Books And Reference Books:


[1]  Thomas A. Powell, “HTML The Complete Reference”, Osborne/McGraw-Hill, ISBN:9780072119770, 0072119772.

[2]  David Flanagan, “JavaScript - The Definitive Guide”, O'Reilly Media, Incorporated, ISBN:9780596805524, 0596805527.

[3]  Rasmus Lerdorf, Kevin Tatroe, Bob Kaehms, Ric McGredy, Nathan Torkington, Paula M. Ferguson, “Programming PHP”, O'Reilly Media, Incorporated, ISBN:9781565926103, 1565926102.

[4]  Saied M.M. Tahaghoghi, Hugh E. Williams, “Learning MySQL”, O'Reilly Media, Incorporated, ISBN:9780596008642, 0596008643;

Essential Reading / Recommended Reading

[1]  Jon Duckett, “HTML and CSS - Design and Build Websites”, Wiley, ISBN: 9781118008188, 1118008189.

[2]  Bryan Pfaffenberger, “HTML, XHTML, and CSS Bible”, Wiley Pub, ISBN: 9788126505401.

[3]  Eric A. Meyer, “CSS Pocket Reference”, O'Reilly Media, ISBN: 9781449313050.

[4]  Axel Rauschmayer, “Speaking JavaScript - An In-Depth Guide for Programmers”, O'Reilly Media, ISBN:9781449364991.

[5]  Addy Osmani, “Learning JavaScript Design Patterns”, O'Reilly Media, ISBN: 9781449334871.

[6]  Josh Lockhart, “Modern PHP - New Features and Good Practices”, O'Reilly Media, ISBN: 9781491904992.

[7]  Matt Doyle, “Beginning PHP 5.3”, Wiley, ISBN: 9781118057346.

[8]  David Sklar, Adam Trachtenberg, “PHP Cookbook”, 3rd Edition, O'Reilly Media, Inc., ISBN: 9781449363758.

Evaluation Pattern

ESE -50%

CIA- 50%

BCA181-1 - ACADEMIC WRITING (2024 Batch)

Total Teaching Hours for Semester:30
No of Lecture Hours/Week:2
Max Marks:50
Credits:2

Course Objectives/Course Description

 

 

This course focuses on preparing students to becoming adept in the various types of writing required during their education. The aim is to introduce students to communication in an academic environment. The application-based modules sensitise students to the function of English language in its various forms. It is instrumental in learners comprehending the role of English in academic and professional realms.

 

  • Introduce learners to the fundamentals of writing in academia.

  • Develop finesse in types of writing used in academic circles

  • Encourage higher order thinking through analysis and representation of ideas  

Learning Outcome

CO1: Comprehension and demonstration of language in the field of technology

CO2: Prepare individuals as Independent communicators

CO3: Illustrate skilled requirements through language proficiency

Unit-1
Teaching Hours:3
UNIT 1
 

Prewriting Strategies: (3hrs)

 

  • Mind mapping

  • Listing

  • Freewriting

  • Word Association

  • Cubing

  • Star bursting (5 Ws)

  • SWOT Analysis

Unit-1
Teaching Hours:3
UNIT 1
 

Prewriting Strategies: (3hrs)

 

  • Mind mapping

  • Listing

  • Freewriting

  • Word Association

  • Cubing

  • Star bursting (5 Ws)

  • SWOT Analysis

Unit-1
Teaching Hours:3
UNIT 1
 

Prewriting Strategies: (3hrs)

 

  • Mind mapping

  • Listing

  • Freewriting

  • Word Association

  • Cubing

  • Star bursting (5 Ws)

  • SWOT Analysis

Unit-1
Teaching Hours:3
UNIT 1
 

Prewriting Strategies: (3hrs)

 

  • Mind mapping

  • Listing

  • Freewriting

  • Word Association

  • Cubing

  • Star bursting (5 Ws)

  • SWOT Analysis

Unit-2
Teaching Hours:8
UNIT 2
 

Paragraph Writing Components: (2hrs)

  • Developing Main Points - Thesis Statement 

  • Supporting Main Points - Topic Sentence

  • Building your standpoint – Explanation

  • Providing examples – Evidence

  • Concluding statement - Link

  • Key words

Types of Paragraphs: (6hrs)

 

  • Descriptive

  • Narrative

  • Expository

  • Argumentative

Unit-2
Teaching Hours:8
UNIT 2
 

Paragraph Writing Components: (2hrs)

  • Developing Main Points - Thesis Statement 

  • Supporting Main Points - Topic Sentence

  • Building your standpoint – Explanation

  • Providing examples – Evidence

  • Concluding statement - Link

  • Key words

Types of Paragraphs: (6hrs)

 

  • Descriptive

  • Narrative

  • Expository

  • Argumentative

Unit-2
Teaching Hours:8
UNIT 2
 

Paragraph Writing Components: (2hrs)

  • Developing Main Points - Thesis Statement 

  • Supporting Main Points - Topic Sentence

  • Building your standpoint – Explanation

  • Providing examples – Evidence

  • Concluding statement - Link

  • Key words

Types of Paragraphs: (6hrs)

 

  • Descriptive

  • Narrative

  • Expository

  • Argumentative

Unit-2
Teaching Hours:8
UNIT 2
 

Paragraph Writing Components: (2hrs)

  • Developing Main Points - Thesis Statement 

  • Supporting Main Points - Topic Sentence

  • Building your standpoint – Explanation

  • Providing examples – Evidence

  • Concluding statement - Link

  • Key words

Types of Paragraphs: (6hrs)

 

  • Descriptive

  • Narrative

  • Expository

  • Argumentative

Unit-3
Teaching Hours:8
UNIT 3
 

Essay Writing Components: (2hrs)

  • Introduction - Opening statement, Background information, Thesis statement

  • Body – Topic sentence, Explanation, Evidence, Link

  • Conclusion – Summary, Intensified Emphasis

Types of Essays: (6hrs)

 

  • Descriptive

  • Narrative

  • Expository

  • Argumentative

Unit-3
Teaching Hours:8
UNIT 3
 

Essay Writing Components: (2hrs)

  • Introduction - Opening statement, Background information, Thesis statement

  • Body – Topic sentence, Explanation, Evidence, Link

  • Conclusion – Summary, Intensified Emphasis

Types of Essays: (6hrs)

 

  • Descriptive

  • Narrative

  • Expository

  • Argumentative

Unit-3
Teaching Hours:8
UNIT 3
 

Essay Writing Components: (2hrs)

  • Introduction - Opening statement, Background information, Thesis statement

  • Body – Topic sentence, Explanation, Evidence, Link

  • Conclusion – Summary, Intensified Emphasis

Types of Essays: (6hrs)

 

  • Descriptive

  • Narrative

  • Expository

  • Argumentative

Unit-3
Teaching Hours:8
UNIT 3
 

Essay Writing Components: (2hrs)

  • Introduction - Opening statement, Background information, Thesis statement

  • Body – Topic sentence, Explanation, Evidence, Link

  • Conclusion – Summary, Intensified Emphasis

Types of Essays: (6hrs)

 

  • Descriptive

  • Narrative

  • Expository

  • Argumentative

Unit-4
Teaching Hours:6
UNIT 4
 

Report Writing Components: (2hrs)

  • Title page

  • Table of contents

  • Executive summary

  • Introduction

  • Discussion

  • Conclusion

  • Recommendations

  • References

Types of Reports: (4hrs)

 

  • Informational 

  • Analytical

  • Progress

Unit-4
Teaching Hours:6
UNIT 4
 

Report Writing Components: (2hrs)

  • Title page

  • Table of contents

  • Executive summary

  • Introduction

  • Discussion

  • Conclusion

  • Recommendations

  • References

Types of Reports: (4hrs)

 

  • Informational 

  • Analytical

  • Progress

Unit-4
Teaching Hours:6
UNIT 4
 

Report Writing Components: (2hrs)

  • Title page

  • Table of contents

  • Executive summary

  • Introduction

  • Discussion

  • Conclusion

  • Recommendations

  • References

Types of Reports: (4hrs)

 

  • Informational 

  • Analytical

  • Progress

Unit-4
Teaching Hours:6
UNIT 4
 

Report Writing Components: (2hrs)

  • Title page

  • Table of contents

  • Executive summary

  • Introduction

  • Discussion

  • Conclusion

  • Recommendations

  • References

Types of Reports: (4hrs)

 

  • Informational 

  • Analytical

  • Progress

Unit-5
Teaching Hours:5
UNIT 5
 

Email Writing Components: (2hrs)

  • Email address

  • Subject line

  • Opening salutation

  • Body of Email

  • Closing Salutation

Types of Email: (3hrs)

 

  • Transactional

  • Broadcast

Unit-5
Teaching Hours:5
UNIT 5
 

Email Writing Components: (2hrs)

  • Email address

  • Subject line

  • Opening salutation

  • Body of Email

  • Closing Salutation

Types of Email: (3hrs)

 

  • Transactional

  • Broadcast

Unit-5
Teaching Hours:5
UNIT 5
 

Email Writing Components: (2hrs)

  • Email address

  • Subject line

  • Opening salutation

  • Body of Email

  • Closing Salutation

Types of Email: (3hrs)

 

  • Transactional

  • Broadcast

Unit-5
Teaching Hours:5
UNIT 5
 

Email Writing Components: (2hrs)

  • Email address

  • Subject line

  • Opening salutation

  • Body of Email

  • Closing Salutation

Types of Email: (3hrs)

 

  • Transactional

  • Broadcast

Text Books And Reference Books:

[1]  Langan, J. (1995). English Skills with Reading (3rd Ed.). McGraw Hill. NewYork.

[2]  Osmond, A. (2013). Academic Writing and Grammar for Students. Sage. Los Angeles.

Essential Reading / Recommended Reading

[1] Robitaille, J. and Connelly, R. (2002).  Writer’s Resource: From Paragraph to Essay. Thomson Heinle. Australia.

Evaluation Pattern

CIA 50%

ESE 50%

BCA101-2 - DISCRETE MATHEMATICS (2024 Batch)

Total Teaching Hours for Semester:45
No of Lecture Hours/Week:3
Max Marks:100
Credits:3

Course Objectives/Course Description

 

This course aims at introducing the students into the world of Discrete Mathematics. It includes the topic like Set Theory, Functions, Matrices, Relations, and Number theory. They gain a historical perspective of the development of modern discrete mathematics and application of the same in the field of Computer Science.

 

Learning Outcome

CO1: Demonstrate a working knowledge of set notation and elementary set theory.

CO2: Apply the different properties of injections, surjections, bijections, compositions, and inverse functions.

CO3: Understand different types of matrices and operations among matrices.

CO4: Determine when a relation is reflexive, symmetric, antisymmetric, or transitive, apply the properties of equivalence relations and partial orderings, and explain the connection between equivalence relations.

CO5: Effectively express the elementary concepts and results of Number theory

Unit-1
Teaching Hours:15
SETS, FUNCTIONS AND MATRICES
 

Sets, Set Operations, Functions, types of functions, Matrices and Matrix operations.

 

Pedagogy​: Lectures, discussions, problem solving and seminars

Unit-1
Teaching Hours:15
SETS, FUNCTIONS AND MATRICES
 

Sets, Set Operations, Functions, types of functions, Matrices and Matrix operations.

 

Pedagogy​: Lectures, discussions, problem solving and seminars

Unit-1
Teaching Hours:15
SETS, FUNCTIONS AND MATRICES
 

Sets, Set Operations, Functions, types of functions, Matrices and Matrix operations.

 

Pedagogy​: Lectures, discussions, problem solving and seminars

Unit-1
Teaching Hours:15
SETS, FUNCTIONS AND MATRICES
 

Sets, Set Operations, Functions, types of functions, Matrices and Matrix operations.

 

Pedagogy​: Lectures, discussions, problem solving and seminars

Unit-2
Teaching Hours:10
RELATIONS
 

Relations and Their Properties, Equivalence Relations, Partial Orderings

 

Unit-2
Teaching Hours:10
RELATIONS
 

Relations and Their Properties, Equivalence Relations, Partial Orderings

 

Unit-2
Teaching Hours:10
RELATIONS
 

Relations and Their Properties, Equivalence Relations, Partial Orderings

 

Unit-2
Teaching Hours:10
RELATIONS
 

Relations and Their Properties, Equivalence Relations, Partial Orderings

 

Unit-3
Teaching Hours:20
NUMBER THEORY
 

Divisibility and Modular Arithmetic, Integer representations, primes and greatest common divisors, solving congruences and its applications.

Unit-3
Teaching Hours:20
NUMBER THEORY
 

Divisibility and Modular Arithmetic, Integer representations, primes and greatest common divisors, solving congruences and its applications.

Unit-3
Teaching Hours:20
NUMBER THEORY
 

Divisibility and Modular Arithmetic, Integer representations, primes and greatest common divisors, solving congruences and its applications.

Unit-3
Teaching Hours:20
NUMBER THEORY
 

Divisibility and Modular Arithmetic, Integer representations, primes and greatest common divisors, solving congruences and its applications.

Text Books And Reference Books:

[1] K. H. Rosen, Discrete Mathematics and its Applications, 7th ed., McGraw – Hill, 2012.

 

Essential Reading / Recommended Reading

[1] R.P. Grimaldi and B.V. Ramana, Discrete and Combinatorial Mathematics, An applied introduction, 5th ed., Pearson Education, 2007.

[2] D. S. Chandrasekharaiah, Discrete Mathematical Structures, 4th ed., India: PRISM Book Pvt. Ltd., 2012.

[3]J. P. Tremblay and R. Manohar, Discrete Mathematical Structures with Application to Computer Science, Reprint, India: Tata McGraw Hill Education, 2008.

Evaluation Pattern

Component

Mode of Assessment

Parameters

Points

CIA I

MCQ,

Written Assignment,

Reference work, etc.,

Mastery of the core concepts

Problem solving skills.

 

10

CIA II

Mid-semester Examination

Basic, conceptual, and analytical knowledge of the subject

25

CIA III

Written Assignment /  Project

Problem solving skills

10

Attendance

Attendance

Regularity and Punctuality

05

ESE

 

Basic, conceptual, and analytical knowledge of the subject

50

Total

100

BCA181-2 - PROFESSIONAL ENGLISH (2024 Batch)

Total Teaching Hours for Semester:30
No of Lecture Hours/Week:2
Max Marks:50
Credits:2

Course Objectives/Course Description

 

 

This course focuses on preparing students to communicate verbally and non-verbally in an effective manner. The aim is to introduce students to communication in a professional environment. The application based modules sensitise students to the function of English language in their careers. It is instrumental in learners comprehending the role of technical English in communication.

 

  • Introduce learners to language skills in their area of specialization.

  • Enable them to enhance career prospects and employability through English language skills

  • Help students gain  understanding of language at the workplace

  • To develop verbal and non-verbal skills in English communication

Learning Outcome

CO1: Comprehension and demonstration of language in the field of technology

CO2: Prepare individuals as Independent communicators

CO3: Illustrate professional requirements through language proficiency

Unit-1
Teaching Hours:8
REVIEWING GRAMMAR
 

This unit undertakes to revise the foundation of language; the grammar section of language learning. Students will be reviewed the grammar aspects mentioned through task based activities

 

  • Concept of time in language – reflective learning will be used to help students detect their grammatical errors in tenses and rectify.

  • Degrees of comparison – using technical literature students can be engaged in apprehending degrees of comparison

  • Direct and reported speech – to enable learners carry on a comprehensible conversation either spoken or written, in a business context

  • Subject verb agreement – through worksheets and task based learning students will be familiarized to construct error free sentences

Unit-1
Teaching Hours:8
REVIEWING GRAMMAR
 

This unit undertakes to revise the foundation of language; the grammar section of language learning. Students will be reviewed the grammar aspects mentioned through task based activities

 

  • Concept of time in language – reflective learning will be used to help students detect their grammatical errors in tenses and rectify.

  • Degrees of comparison – using technical literature students can be engaged in apprehending degrees of comparison

  • Direct and reported speech – to enable learners carry on a comprehensible conversation either spoken or written, in a business context

  • Subject verb agreement – through worksheets and task based learning students will be familiarized to construct error free sentences

Unit-1
Teaching Hours:8
REVIEWING GRAMMAR
 

This unit undertakes to revise the foundation of language; the grammar section of language learning. Students will be reviewed the grammar aspects mentioned through task based activities

 

  • Concept of time in language – reflective learning will be used to help students detect their grammatical errors in tenses and rectify.

  • Degrees of comparison – using technical literature students can be engaged in apprehending degrees of comparison

  • Direct and reported speech – to enable learners carry on a comprehensible conversation either spoken or written, in a business context

  • Subject verb agreement – through worksheets and task based learning students will be familiarized to construct error free sentences

Unit-1
Teaching Hours:8
REVIEWING GRAMMAR
 

This unit undertakes to revise the foundation of language; the grammar section of language learning. Students will be reviewed the grammar aspects mentioned through task based activities

 

  • Concept of time in language – reflective learning will be used to help students detect their grammatical errors in tenses and rectify.

  • Degrees of comparison – using technical literature students can be engaged in apprehending degrees of comparison

  • Direct and reported speech – to enable learners carry on a comprehensible conversation either spoken or written, in a business context

  • Subject verb agreement – through worksheets and task based learning students will be familiarized to construct error free sentences

Unit-2
Teaching Hours:2
TECHNICAL VOCABULARY
 

Learners will be acquainted with the basic of English language learning. They will be taught to identifying technical vocabulary from the general. Technical magazines prescribed by the institution that are subject specific can be used as teaching tools.

 

  • Introduction to technical lexicon – help students identify jargon and technical terminologies. Assist them comprehend the significance of implementation with moderation through their subject literature.

  • Internet lexis and contextualisation – provide meanings accurately to ensure right exercise of terms in a professional scenario through hands-on experience 

  • Circumstantial usage of diction – aid the comprehension of word usage as verbs and nouns based on the requirement. Differentiating the meanings of synonyms and their orientation in a text

  • Integrating technical vocabulary in describing process and procedure – through prescribed texts students can be made to enhance their language by right integration of diction.

  • Mind mapping of textual diction and allied words – diagrammatically mapping of words based on their meaning, context and usage will re-emphasise the words in the minds of the learners

Unit-2
Teaching Hours:2
TECHNICAL VOCABULARY
 

Learners will be acquainted with the basic of English language learning. They will be taught to identifying technical vocabulary from the general. Technical magazines prescribed by the institution that are subject specific can be used as teaching tools.

 

  • Introduction to technical lexicon – help students identify jargon and technical terminologies. Assist them comprehend the significance of implementation with moderation through their subject literature.

  • Internet lexis and contextualisation – provide meanings accurately to ensure right exercise of terms in a professional scenario through hands-on experience 

  • Circumstantial usage of diction – aid the comprehension of word usage as verbs and nouns based on the requirement. Differentiating the meanings of synonyms and their orientation in a text

  • Integrating technical vocabulary in describing process and procedure – through prescribed texts students can be made to enhance their language by right integration of diction.

  • Mind mapping of textual diction and allied words – diagrammatically mapping of words based on their meaning, context and usage will re-emphasise the words in the minds of the learners

Unit-2
Teaching Hours:2
TECHNICAL VOCABULARY
 

Learners will be acquainted with the basic of English language learning. They will be taught to identifying technical vocabulary from the general. Technical magazines prescribed by the institution that are subject specific can be used as teaching tools.

 

  • Introduction to technical lexicon – help students identify jargon and technical terminologies. Assist them comprehend the significance of implementation with moderation through their subject literature.

  • Internet lexis and contextualisation – provide meanings accurately to ensure right exercise of terms in a professional scenario through hands-on experience 

  • Circumstantial usage of diction – aid the comprehension of word usage as verbs and nouns based on the requirement. Differentiating the meanings of synonyms and their orientation in a text

  • Integrating technical vocabulary in describing process and procedure – through prescribed texts students can be made to enhance their language by right integration of diction.

  • Mind mapping of textual diction and allied words – diagrammatically mapping of words based on their meaning, context and usage will re-emphasise the words in the minds of the learners

Unit-2
Teaching Hours:2
TECHNICAL VOCABULARY
 

Learners will be acquainted with the basic of English language learning. They will be taught to identifying technical vocabulary from the general. Technical magazines prescribed by the institution that are subject specific can be used as teaching tools.

 

  • Introduction to technical lexicon – help students identify jargon and technical terminologies. Assist them comprehend the significance of implementation with moderation through their subject literature.

  • Internet lexis and contextualisation – provide meanings accurately to ensure right exercise of terms in a professional scenario through hands-on experience 

  • Circumstantial usage of diction – aid the comprehension of word usage as verbs and nouns based on the requirement. Differentiating the meanings of synonyms and their orientation in a text

  • Integrating technical vocabulary in describing process and procedure – through prescribed texts students can be made to enhance their language by right integration of diction.

  • Mind mapping of textual diction and allied words – diagrammatically mapping of words based on their meaning, context and usage will re-emphasise the words in the minds of the learners

Unit-3
Teaching Hours:8
SPEAKING SKILLS
 

The previous semester dealt with a few productive oral skills. Furthering their productive expertise, speaking skills are taken into consideration. Students will be encouraged to demonstrate their skills under guidance of the teacher.

Interview – types of interviews can be elaborated to the learners. The essential language and skills required must be emphasised verbally and through case studies. Students can be encouraged to demonstrate the acquired knowledge through simulated sessions

 

  • Presentations – the critical features and language checklists must be emphasised. Introducing the topic, linking, sequencing and dealing with questions must be mad familiar. The soft skills and paralinguistic aspects can be taught through examples. Group demonstrations must be mandatory

  • Conference – the soft skills and language finesse required must be made clear to the students. Checklists can be provided as learning aids. Chairing sessions, targeting issues, key language, and steering the meeting is required to be acquainted. Audio visual examples can be screened and re-emphasis through practice sessions can be carried out.

Unit-3
Teaching Hours:8
SPEAKING SKILLS
 

The previous semester dealt with a few productive oral skills. Furthering their productive expertise, speaking skills are taken into consideration. Students will be encouraged to demonstrate their skills under guidance of the teacher.

Interview – types of interviews can be elaborated to the learners. The essential language and skills required must be emphasised verbally and through case studies. Students can be encouraged to demonstrate the acquired knowledge through simulated sessions

 

  • Presentations – the critical features and language checklists must be emphasised. Introducing the topic, linking, sequencing and dealing with questions must be mad familiar. The soft skills and paralinguistic aspects can be taught through examples. Group demonstrations must be mandatory

  • Conference – the soft skills and language finesse required must be made clear to the students. Checklists can be provided as learning aids. Chairing sessions, targeting issues, key language, and steering the meeting is required to be acquainted. Audio visual examples can be screened and re-emphasis through practice sessions can be carried out.

Unit-3
Teaching Hours:8
SPEAKING SKILLS
 

The previous semester dealt with a few productive oral skills. Furthering their productive expertise, speaking skills are taken into consideration. Students will be encouraged to demonstrate their skills under guidance of the teacher.

Interview – types of interviews can be elaborated to the learners. The essential language and skills required must be emphasised verbally and through case studies. Students can be encouraged to demonstrate the acquired knowledge through simulated sessions

 

  • Presentations – the critical features and language checklists must be emphasised. Introducing the topic, linking, sequencing and dealing with questions must be mad familiar. The soft skills and paralinguistic aspects can be taught through examples. Group demonstrations must be mandatory

  • Conference – the soft skills and language finesse required must be made clear to the students. Checklists can be provided as learning aids. Chairing sessions, targeting issues, key language, and steering the meeting is required to be acquainted. Audio visual examples can be screened and re-emphasis through practice sessions can be carried out.

Unit-3
Teaching Hours:8
SPEAKING SKILLS
 

The previous semester dealt with a few productive oral skills. Furthering their productive expertise, speaking skills are taken into consideration. Students will be encouraged to demonstrate their skills under guidance of the teacher.

Interview – types of interviews can be elaborated to the learners. The essential language and skills required must be emphasised verbally and through case studies. Students can be encouraged to demonstrate the acquired knowledge through simulated sessions

 

  • Presentations – the critical features and language checklists must be emphasised. Introducing the topic, linking, sequencing and dealing with questions must be mad familiar. The soft skills and paralinguistic aspects can be taught through examples. Group demonstrations must be mandatory

  • Conference – the soft skills and language finesse required must be made clear to the students. Checklists can be provided as learning aids. Chairing sessions, targeting issues, key language, and steering the meeting is required to be acquainted. Audio visual examples can be screened and re-emphasis through practice sessions can be carried out.

Unit-4
Teaching Hours:4
NON ? VERBAL COMMUNICATION
 

The ancillaries of speaking skill is in focus here. Prior to delving into the productive skill, the nitty gritty that enhance its effectiveness is made familiar to the learner. Classroom activities and vicarious learning through case studies and video clippings can be screened.

 

  • Competence in non-verbal communication- create an awareness of the role of non-verbal communication in a professional set-up

  • Functions of non-verbal communication – the various utilities of nonverbal communication can be elaborated to students with case studies

  • Benefits of non-verbal communication – elucidate the advantages of non-verbal communication with reference to cultural distinctions

  • Proxemics, Chronemics, Kinesics, Haptics, Gestures, Paralanguage - vicarious learning of these aspects of non-verbal communication can be carried out through video clippings of suitable material and print media

Unit-4
Teaching Hours:4
NON ? VERBAL COMMUNICATION
 

The ancillaries of speaking skill is in focus here. Prior to delving into the productive skill, the nitty gritty that enhance its effectiveness is made familiar to the learner. Classroom activities and vicarious learning through case studies and video clippings can be screened.

 

  • Competence in non-verbal communication- create an awareness of the role of non-verbal communication in a professional set-up

  • Functions of non-verbal communication – the various utilities of nonverbal communication can be elaborated to students with case studies

  • Benefits of non-verbal communication – elucidate the advantages of non-verbal communication with reference to cultural distinctions

  • Proxemics, Chronemics, Kinesics, Haptics, Gestures, Paralanguage - vicarious learning of these aspects of non-verbal communication can be carried out through video clippings of suitable material and print media

Unit-4
Teaching Hours:4
NON ? VERBAL COMMUNICATION
 

The ancillaries of speaking skill is in focus here. Prior to delving into the productive skill, the nitty gritty that enhance its effectiveness is made familiar to the learner. Classroom activities and vicarious learning through case studies and video clippings can be screened.

 

  • Competence in non-verbal communication- create an awareness of the role of non-verbal communication in a professional set-up

  • Functions of non-verbal communication – the various utilities of nonverbal communication can be elaborated to students with case studies

  • Benefits of non-verbal communication – elucidate the advantages of non-verbal communication with reference to cultural distinctions

  • Proxemics, Chronemics, Kinesics, Haptics, Gestures, Paralanguage - vicarious learning of these aspects of non-verbal communication can be carried out through video clippings of suitable material and print media

Unit-4
Teaching Hours:4
NON ? VERBAL COMMUNICATION
 

The ancillaries of speaking skill is in focus here. Prior to delving into the productive skill, the nitty gritty that enhance its effectiveness is made familiar to the learner. Classroom activities and vicarious learning through case studies and video clippings can be screened.

 

  • Competence in non-verbal communication- create an awareness of the role of non-verbal communication in a professional set-up

  • Functions of non-verbal communication – the various utilities of nonverbal communication can be elaborated to students with case studies

  • Benefits of non-verbal communication – elucidate the advantages of non-verbal communication with reference to cultural distinctions

  • Proxemics, Chronemics, Kinesics, Haptics, Gestures, Paralanguage - vicarious learning of these aspects of non-verbal communication can be carried out through video clippings of suitable material and print media

Unit-5
Teaching Hours:4
COMMUNICATION STRATEGIES
 

The productive skills are finessed through identification and refining of the elements mentioned in this unit. They contribute to holistic presentation. Task based activities must be used to practise. Business Communication texts and worksheets will provide ample support.

Nuances of Communication – communication in the work place requires knowing the dos and don’ts of professional communication. An introduction to listening, speaking, reading and writing with reference to professional communication can be provided.

  • Opening techniques

  •  Speech markers

  •  Fillers

  • Turn taking

  • Backchannelling

  • Dealing with interruptions 

 

every element mentioned can be elaborated. Ample examples can be provided through audio visual media, it can be provided to them through demonstrations and verbal reinforcement language checklists can be provided to aid students understand implementation of the elements. A follow up through mock sessions must be carried out in groups

Unit-5
Teaching Hours:4
COMMUNICATION STRATEGIES
 

The productive skills are finessed through identification and refining of the elements mentioned in this unit. They contribute to holistic presentation. Task based activities must be used to practise. Business Communication texts and worksheets will provide ample support.

Nuances of Communication – communication in the work place requires knowing the dos and don’ts of professional communication. An introduction to listening, speaking, reading and writing with reference to professional communication can be provided.

  • Opening techniques

  •  Speech markers

  •  Fillers

  • Turn taking

  • Backchannelling

  • Dealing with interruptions 

 

every element mentioned can be elaborated. Ample examples can be provided through audio visual media, it can be provided to them through demonstrations and verbal reinforcement language checklists can be provided to aid students understand implementation of the elements. A follow up through mock sessions must be carried out in groups

Unit-5
Teaching Hours:4
COMMUNICATION STRATEGIES
 

The productive skills are finessed through identification and refining of the elements mentioned in this unit. They contribute to holistic presentation. Task based activities must be used to practise. Business Communication texts and worksheets will provide ample support.

Nuances of Communication – communication in the work place requires knowing the dos and don’ts of professional communication. An introduction to listening, speaking, reading and writing with reference to professional communication can be provided.

  • Opening techniques

  •  Speech markers

  •  Fillers

  • Turn taking

  • Backchannelling

  • Dealing with interruptions 

 

every element mentioned can be elaborated. Ample examples can be provided through audio visual media, it can be provided to them through demonstrations and verbal reinforcement language checklists can be provided to aid students understand implementation of the elements. A follow up through mock sessions must be carried out in groups

Unit-5
Teaching Hours:4
COMMUNICATION STRATEGIES
 

The productive skills are finessed through identification and refining of the elements mentioned in this unit. They contribute to holistic presentation. Task based activities must be used to practise. Business Communication texts and worksheets will provide ample support.

Nuances of Communication – communication in the work place requires knowing the dos and don’ts of professional communication. An introduction to listening, speaking, reading and writing with reference to professional communication can be provided.

  • Opening techniques

  •  Speech markers

  •  Fillers

  • Turn taking

  • Backchannelling

  • Dealing with interruptions 

 

every element mentioned can be elaborated. Ample examples can be provided through audio visual media, it can be provided to them through demonstrations and verbal reinforcement language checklists can be provided to aid students understand implementation of the elements. A follow up through mock sessions must be carried out in groups

Unit-6
Teaching Hours:4
PROFESSIONAL COMMUNICATION
 

Lastly students will be introduced to typical work scenarios through hands-on sessions. 

  • Small talk – the purpose and role of small talk must be taught to the students. They can be screened video clippings of the same. Mock sessions can be performed in the class. The key phrases and language used can be imparted through provision of language worksheets and skills checklists

  • Meeting- types of meetings, hierarchy of most often featuring members, etiquette to be held at meeting and the duties to be performed can be taught implicitly. Chairing, setting the agenda, controlling the smooth functioning, participating, deliberating and diplomacy must be made clear. The key phrases and language used can be taught through language worksheets and skills checklists

 

  • Group discussion – group discussions are carried out at every level. Students must be familiarized with the basics of a group discussions. Agreeing, disagreeing, and being diplomatic are essentials to be imparted. The soft skills and language essentials most commonly noted can be made comprehensible to the students. Vicarious learning and language charts can be used as learning tools.

Unit-6
Teaching Hours:4
PROFESSIONAL COMMUNICATION
 

Lastly students will be introduced to typical work scenarios through hands-on sessions. 

  • Small talk – the purpose and role of small talk must be taught to the students. They can be screened video clippings of the same. Mock sessions can be performed in the class. The key phrases and language used can be imparted through provision of language worksheets and skills checklists

  • Meeting- types of meetings, hierarchy of most often featuring members, etiquette to be held at meeting and the duties to be performed can be taught implicitly. Chairing, setting the agenda, controlling the smooth functioning, participating, deliberating and diplomacy must be made clear. The key phrases and language used can be taught through language worksheets and skills checklists

 

  • Group discussion – group discussions are carried out at every level. Students must be familiarized with the basics of a group discussions. Agreeing, disagreeing, and being diplomatic are essentials to be imparted. The soft skills and language essentials most commonly noted can be made comprehensible to the students. Vicarious learning and language charts can be used as learning tools.

Unit-6
Teaching Hours:4
PROFESSIONAL COMMUNICATION
 

Lastly students will be introduced to typical work scenarios through hands-on sessions. 

  • Small talk – the purpose and role of small talk must be taught to the students. They can be screened video clippings of the same. Mock sessions can be performed in the class. The key phrases and language used can be imparted through provision of language worksheets and skills checklists

  • Meeting- types of meetings, hierarchy of most often featuring members, etiquette to be held at meeting and the duties to be performed can be taught implicitly. Chairing, setting the agenda, controlling the smooth functioning, participating, deliberating and diplomacy must be made clear. The key phrases and language used can be taught through language worksheets and skills checklists

 

  • Group discussion – group discussions are carried out at every level. Students must be familiarized with the basics of a group discussions. Agreeing, disagreeing, and being diplomatic are essentials to be imparted. The soft skills and language essentials most commonly noted can be made comprehensible to the students. Vicarious learning and language charts can be used as learning tools.

Unit-6
Teaching Hours:4
PROFESSIONAL COMMUNICATION
 

Lastly students will be introduced to typical work scenarios through hands-on sessions. 

  • Small talk – the purpose and role of small talk must be taught to the students. They can be screened video clippings of the same. Mock sessions can be performed in the class. The key phrases and language used can be imparted through provision of language worksheets and skills checklists

  • Meeting- types of meetings, hierarchy of most often featuring members, etiquette to be held at meeting and the duties to be performed can be taught implicitly. Chairing, setting the agenda, controlling the smooth functioning, participating, deliberating and diplomacy must be made clear. The key phrases and language used can be taught through language worksheets and skills checklists

 

  • Group discussion – group discussions are carried out at every level. Students must be familiarized with the basics of a group discussions. Agreeing, disagreeing, and being diplomatic are essentials to be imparted. The soft skills and language essentials most commonly noted can be made comprehensible to the students. Vicarious learning and language charts can be used as learning tools.

Text Books And Reference Books:

[1] Driscoll, Liz. Common Mistakes at Intermediate and How to Avoid Them. CUP, 2008.

[2] Carter, Ronald and Michael McCarthy. Cambridge Grammar of English. CUP, 2006.

 

[3] Leech, Geoffrey, Jan Svartvik. A Communicative Grammar of English. Third Edition. New Delhi: Pearson Education, 2009.

Essential Reading / Recommended Reading

[1] Booher, Dianna. E- Writing: 21st Century Tools for Effective Communication. Macmillan, 2008.

 

[2] Knapp .M. Essentials of Non-Verbal Communication Theory Rea. FL: Harcourt, 1995.

Evaluation Pattern

CIA 50%

ESE 50%

BCA201-2 - DATA STRUCTURES USING C++ (2024 Batch)

Total Teaching Hours for Semester:90
No of Lecture Hours/Week:6
Max Marks:100
Credits:4

Course Objectives/Course Description

 

 

This course provides a basic concept of Abstract Data Types, Linear and Non-Linear Data structures, and the behaviour of data structures such as stacks, queues, trees, hash tables, search trees, Graphs and their representations. This Course also analyse various searching and sorting algorithms and also implements ADTs such as lists, stacks, queues, trees, graphs, search trees in C++ to solve problems.

Learning Outcome

CO1: Demonstrate an understanding of the appropriate data structures to represent data items in real world and to analyse the time and space complexities of algorithms.

CO2: Analyse and implement various kinds of searching and sorting techniques.

CO3: Apply the concept of various data structures such as stacks, queues, lists, trees and graphs

Unit-1
Teaching Hours:18
ARRAYS
 

Algorithms, performance analysis‐ time complexity and space complexity, Algorithm Analysis, Asymptotic Notations, Abstract Data Types, An Introduction to C++ Class- Data Abstraction and Encapsulation in C++- Declaring Class Objects and Invoking Member Functions- Special Class Operations- Miscellaneous Topics- ADTs and C++Classes, The Array as an Abstract Data Type, The Polynomial Abstract Data type- Polynomial Representation- Polynomial Addition. Sparse Matrices, Introduction- Sparse Matrix Representation- Transposing a Matrix- Matrix Multiplication, Representation of Arrays.

Lab Exercises:

  1.  Program to implement Sparse Matrix
  2. Program to find the Transpose of a Matrix and Matrix Multiplication
  3. Write a C++ programs to implement Linear search
Unit-1
Teaching Hours:18
ARRAYS
 

Algorithms, performance analysis‐ time complexity and space complexity, Algorithm Analysis, Asymptotic Notations, Abstract Data Types, An Introduction to C++ Class- Data Abstraction and Encapsulation in C++- Declaring Class Objects and Invoking Member Functions- Special Class Operations- Miscellaneous Topics- ADTs and C++Classes, The Array as an Abstract Data Type, The Polynomial Abstract Data type- Polynomial Representation- Polynomial Addition. Sparse Matrices, Introduction- Sparse Matrix Representation- Transposing a Matrix- Matrix Multiplication, Representation of Arrays.

Lab Exercises:

  1.  Program to implement Sparse Matrix
  2. Program to find the Transpose of a Matrix and Matrix Multiplication
  3. Write a C++ programs to implement Linear search
Unit-1
Teaching Hours:18
ARRAYS
 

Algorithms, performance analysis‐ time complexity and space complexity, Algorithm Analysis, Asymptotic Notations, Abstract Data Types, An Introduction to C++ Class- Data Abstraction and Encapsulation in C++- Declaring Class Objects and Invoking Member Functions- Special Class Operations- Miscellaneous Topics- ADTs and C++Classes, The Array as an Abstract Data Type, The Polynomial Abstract Data type- Polynomial Representation- Polynomial Addition. Sparse Matrices, Introduction- Sparse Matrix Representation- Transposing a Matrix- Matrix Multiplication, Representation of Arrays.

Lab Exercises:

  1.  Program to implement Sparse Matrix
  2. Program to find the Transpose of a Matrix and Matrix Multiplication
  3. Write a C++ programs to implement Linear search
Unit-1
Teaching Hours:18
ARRAYS
 

Algorithms, performance analysis‐ time complexity and space complexity, Algorithm Analysis, Asymptotic Notations, Abstract Data Types, An Introduction to C++ Class- Data Abstraction and Encapsulation in C++- Declaring Class Objects and Invoking Member Functions- Special Class Operations- Miscellaneous Topics- ADTs and C++Classes, The Array as an Abstract Data Type, The Polynomial Abstract Data type- Polynomial Representation- Polynomial Addition. Sparse Matrices, Introduction- Sparse Matrix Representation- Transposing a Matrix- Matrix Multiplication, Representation of Arrays.

Lab Exercises:

  1.  Program to implement Sparse Matrix
  2. Program to find the Transpose of a Matrix and Matrix Multiplication
  3. Write a C++ programs to implement Linear search
Unit-2
Teaching Hours:18
List ADT
 

Linear list ADT-array representation and linked representation, Singly Linked Lists- Operations-Insertion, Deletion, Circular linked lists-Operations for Circularly linked lists, Doubly Linked Lists- Operations- Insertion, Deletion.

 

Lab Exercises:

1. Write a C++ programs to implement single list ADT to perform following operations 

a. Insert an element into a list.

b. Delete an element from list

c. Search for a key element in list 

d. count number of nodes in list

 

2. Write a C++ programs to implement Doubly list ADT to perform following operations 

a.  Insert an element into a list

b. Delete an element from list

c. Search for a key element in list

d. count number of nodes in list

Unit-2
Teaching Hours:18
List ADT
 

Linear list ADT-array representation and linked representation, Singly Linked Lists- Operations-Insertion, Deletion, Circular linked lists-Operations for Circularly linked lists, Doubly Linked Lists- Operations- Insertion, Deletion.

 

Lab Exercises:

1. Write a C++ programs to implement single list ADT to perform following operations 

a. Insert an element into a list.

b. Delete an element from list

c. Search for a key element in list 

d. count number of nodes in list

 

2. Write a C++ programs to implement Doubly list ADT to perform following operations 

a.  Insert an element into a list

b. Delete an element from list

c. Search for a key element in list

d. count number of nodes in list

Unit-2
Teaching Hours:18
List ADT
 

Linear list ADT-array representation and linked representation, Singly Linked Lists- Operations-Insertion, Deletion, Circular linked lists-Operations for Circularly linked lists, Doubly Linked Lists- Operations- Insertion, Deletion.

 

Lab Exercises:

1. Write a C++ programs to implement single list ADT to perform following operations 

a. Insert an element into a list.

b. Delete an element from list

c. Search for a key element in list 

d. count number of nodes in list

 

2. Write a C++ programs to implement Doubly list ADT to perform following operations 

a.  Insert an element into a list

b. Delete an element from list

c. Search for a key element in list

d. count number of nodes in list

Unit-2
Teaching Hours:18
List ADT
 

Linear list ADT-array representation and linked representation, Singly Linked Lists- Operations-Insertion, Deletion, Circular linked lists-Operations for Circularly linked lists, Doubly Linked Lists- Operations- Insertion, Deletion.

 

Lab Exercises:

1. Write a C++ programs to implement single list ADT to perform following operations 

a. Insert an element into a list.

b. Delete an element from list

c. Search for a key element in list 

d. count number of nodes in list

 

2. Write a C++ programs to implement Doubly list ADT to perform following operations 

a.  Insert an element into a list

b. Delete an element from list

c. Search for a key element in list

d. count number of nodes in list

Unit-3
Teaching Hours:18
STACKS AND QUEUES
 

Stack ADT, definition, array and linked implementations, applications-infix to postfix conversion, Postfix expression evaluation, recursion implementation, Queue ADT, definition, array and linked Implementations, Circular queues-Insertion and deletion operations.

Lab Exercises:

1. Write a C++ programs to implement a Stack using ADT

2. Write a C++ programs to implement a Queue using ADT

Unit-3
Teaching Hours:18
STACKS AND QUEUES
 

Stack ADT, definition, array and linked implementations, applications-infix to postfix conversion, Postfix expression evaluation, recursion implementation, Queue ADT, definition, array and linked Implementations, Circular queues-Insertion and deletion operations.

Lab Exercises:

1. Write a C++ programs to implement a Stack using ADT

2. Write a C++ programs to implement a Queue using ADT

Unit-3
Teaching Hours:18
STACKS AND QUEUES
 

Stack ADT, definition, array and linked implementations, applications-infix to postfix conversion, Postfix expression evaluation, recursion implementation, Queue ADT, definition, array and linked Implementations, Circular queues-Insertion and deletion operations.

Lab Exercises:

1. Write a C++ programs to implement a Stack using ADT

2. Write a C++ programs to implement a Queue using ADT

Unit-3
Teaching Hours:18
STACKS AND QUEUES
 

Stack ADT, definition, array and linked implementations, applications-infix to postfix conversion, Postfix expression evaluation, recursion implementation, Queue ADT, definition, array and linked Implementations, Circular queues-Insertion and deletion operations.

Lab Exercises:

1. Write a C++ programs to implement a Stack using ADT

2. Write a C++ programs to implement a Queue using ADT

Unit-4
Teaching Hours:18
SEARCHING AND SORTING
 

Searching - Linear Search, Binary Search, Hashing-Introduction, hash tables, ash functions, Overflow Handling, Comparison of Searching methods.

Sorting-Insertion Sort, Selection Sort, Bubble Sort, Quick sort, Heap Sort, Merge sort, Comparison of Sorting methods.

Lab Exercises: 

1. Write a C++ programs to implement Binary search 

2. Write a C++ programs to implement Quick sort and Selection sort

Unit-4
Teaching Hours:18
SEARCHING AND SORTING
 

Searching - Linear Search, Binary Search, Hashing-Introduction, hash tables, ash functions, Overflow Handling, Comparison of Searching methods.

Sorting-Insertion Sort, Selection Sort, Bubble Sort, Quick sort, Heap Sort, Merge sort, Comparison of Sorting methods.

Lab Exercises: 

1. Write a C++ programs to implement Binary search 

2. Write a C++ programs to implement Quick sort and Selection sort

Unit-4
Teaching Hours:18
SEARCHING AND SORTING
 

Searching - Linear Search, Binary Search, Hashing-Introduction, hash tables, ash functions, Overflow Handling, Comparison of Searching methods.

Sorting-Insertion Sort, Selection Sort, Bubble Sort, Quick sort, Heap Sort, Merge sort, Comparison of Sorting methods.

Lab Exercises: 

1. Write a C++ programs to implement Binary search 

2. Write a C++ programs to implement Quick sort and Selection sort

Unit-4
Teaching Hours:18
SEARCHING AND SORTING
 

Searching - Linear Search, Binary Search, Hashing-Introduction, hash tables, ash functions, Overflow Handling, Comparison of Searching methods.

Sorting-Insertion Sort, Selection Sort, Bubble Sort, Quick sort, Heap Sort, Merge sort, Comparison of Sorting methods.

Lab Exercises: 

1. Write a C++ programs to implement Binary search 

2. Write a C++ programs to implement Quick sort and Selection sort

Unit-5
Teaching Hours:18
TREES & GRAPHS
 

Trees: Introduction, Terminology, Representation of Trees, Binary Trees, The Abstract Data Type, Properties of Binary Tress, Binary Tree Representations, Binary Tree Traversal. Introduction, Inorder Traversal, Preorder Traversal, Postorder Traversal. Binary Search Trees, Definition, Implementation, Operations‐ Searching, Insertion and Deletion

Graphs: Basic terminology, representation of graphs, graph search methods DFS, BFS.  

Lab Exercises:

1. Write C++ programs to traverse the given binary tree in inorder and postorder.

2. Write a C++ program to perform the following operations:

a) Insert an element into a binary search tree. 

b) Delete an element from a binary search tree.

c) Search for a key element in a binary search tree.

 

Unit-5
Teaching Hours:18
TREES & GRAPHS
 

Trees: Introduction, Terminology, Representation of Trees, Binary Trees, The Abstract Data Type, Properties of Binary Tress, Binary Tree Representations, Binary Tree Traversal. Introduction, Inorder Traversal, Preorder Traversal, Postorder Traversal. Binary Search Trees, Definition, Implementation, Operations‐ Searching, Insertion and Deletion

Graphs: Basic terminology, representation of graphs, graph search methods DFS, BFS.  

Lab Exercises:

1. Write C++ programs to traverse the given binary tree in inorder and postorder.

2. Write a C++ program to perform the following operations:

a) Insert an element into a binary search tree. 

b) Delete an element from a binary search tree.

c) Search for a key element in a binary search tree.

 

Unit-5
Teaching Hours:18
TREES & GRAPHS
 

Trees: Introduction, Terminology, Representation of Trees, Binary Trees, The Abstract Data Type, Properties of Binary Tress, Binary Tree Representations, Binary Tree Traversal. Introduction, Inorder Traversal, Preorder Traversal, Postorder Traversal. Binary Search Trees, Definition, Implementation, Operations‐ Searching, Insertion and Deletion

Graphs: Basic terminology, representation of graphs, graph search methods DFS, BFS.  

Lab Exercises:

1. Write C++ programs to traverse the given binary tree in inorder and postorder.

2. Write a C++ program to perform the following operations:

a) Insert an element into a binary search tree. 

b) Delete an element from a binary search tree.

c) Search for a key element in a binary search tree.

 

Unit-5
Teaching Hours:18
TREES & GRAPHS
 

Trees: Introduction, Terminology, Representation of Trees, Binary Trees, The Abstract Data Type, Properties of Binary Tress, Binary Tree Representations, Binary Tree Traversal. Introduction, Inorder Traversal, Preorder Traversal, Postorder Traversal. Binary Search Trees, Definition, Implementation, Operations‐ Searching, Insertion and Deletion

Graphs: Basic terminology, representation of graphs, graph search methods DFS, BFS.  

Lab Exercises:

1. Write C++ programs to traverse the given binary tree in inorder and postorder.

2. Write a C++ program to perform the following operations:

a) Insert an element into a binary search tree. 

b) Delete an element from a binary search tree.

c) Search for a key element in a binary search tree.

 

Text Books And Reference Books:
  1. Data structures, Algorithms and Applications in C++, S.Sahni, University Press (India) Pvt.Ltd, 2nd edition, Universities Press, Pvt. Ltd.
  2. Data structures and Algorithm Analysis in C++, Mark Allen Weiss, Pearson Education. Ltd., Second Edition.
  3. Data structures and Algorithms in C++, Michael T.Goodrich, R.Tamassia and .Mount, Wiley student edition, John Wiley and Sons.

 

Essential Reading / Recommended Reading

 

  1. Data structures and algorithms in C++, 3rd Edition, Adam Drozdek, Thomson
  2. Data structures using C and C++, Langsam, Augenstein and Tanenbaum, PHI.
  3. Problem solving with C++, The OOP, Fourth edition, W.Savitch, Pearson education.
Evaluation Pattern

ESE - 50%

CIA - 50%

BCA202-2 - JAVA PROGRAMMING (2024 Batch)

Total Teaching Hours for Semester:90
No of Lecture Hours/Week:6
Max Marks:150
Credits:5

Course Objectives/Course Description

 

The objective of this course is to teach the object oriented principles and advanced features in Java technologies. The practical sessions planned along with this course make the students industry ready in java platform. Students will be developing  and  testing java application as a practical course work.  The course introduces the concept of UI design in java using SWING and JAVAFX

Learning Outcome

CO1: Understanding and applying the principles of object-oriented programming in the construction of robust, maintainable programs.

CO2: Analyze the various societal and environmental problems critically to develop solutions using the features of programming language.

CO3: Develop sustainable and innovative solutions for real-time problems.

Unit-1
Teaching Hours:18
ARRAYS AND CLASSES
 

Declaring Arrays -  Accessing Array Elements – For Each loop – Array Copying -  Command-Line Parameters – Array Sorting – Multi Dimensional Arrays – Ragged Arrays

Classes and Objects 

General Form of a Class- Declaring Objects – Introducing Methods – Parameterized Methods-Method Overloading – Using Objects as Parameters - Constructors –  Parameterized Constructors - Constructor Overloading  – this keyword – Garbage collection -   Introducing Access Control – Understanding Static - Relationship Between Classes – Using Predefined Classes- Mutator and Accessor Methods

Lab Exercises:

1. Identify a domain of your choice, list out ten entities in the domain. For each entity, identify minimum 10 attributes and assign the data type for each attribute with proper justification.

2. Implement the concept of class, data members, member functions and access specifiers.

3. Implement the concept of array of objects with constructor and function overloading


Unit-1
Teaching Hours:18
ARRAYS AND CLASSES
 

Declaring Arrays -  Accessing Array Elements – For Each loop – Array Copying -  Command-Line Parameters – Array Sorting – Multi Dimensional Arrays – Ragged Arrays

Classes and Objects 

General Form of a Class- Declaring Objects – Introducing Methods – Parameterized Methods-Method Overloading – Using Objects as Parameters - Constructors –  Parameterized Constructors - Constructor Overloading  – this keyword – Garbage collection -   Introducing Access Control – Understanding Static - Relationship Between Classes – Using Predefined Classes- Mutator and Accessor Methods

Lab Exercises:

1. Identify a domain of your choice, list out ten entities in the domain. For each entity, identify minimum 10 attributes and assign the data type for each attribute with proper justification.

2. Implement the concept of class, data members, member functions and access specifiers.

3. Implement the concept of array of objects with constructor and function overloading


Unit-1
Teaching Hours:18
ARRAYS AND CLASSES
 

Declaring Arrays -  Accessing Array Elements – For Each loop – Array Copying -  Command-Line Parameters – Array Sorting – Multi Dimensional Arrays – Ragged Arrays

Classes and Objects 

General Form of a Class- Declaring Objects – Introducing Methods – Parameterized Methods-Method Overloading – Using Objects as Parameters - Constructors –  Parameterized Constructors - Constructor Overloading  – this keyword – Garbage collection -   Introducing Access Control – Understanding Static - Relationship Between Classes – Using Predefined Classes- Mutator and Accessor Methods

Lab Exercises:

1. Identify a domain of your choice, list out ten entities in the domain. For each entity, identify minimum 10 attributes and assign the data type for each attribute with proper justification.

2. Implement the concept of class, data members, member functions and access specifiers.

3. Implement the concept of array of objects with constructor and function overloading


Unit-1
Teaching Hours:18
ARRAYS AND CLASSES
 

Declaring Arrays -  Accessing Array Elements – For Each loop – Array Copying -  Command-Line Parameters – Array Sorting – Multi Dimensional Arrays – Ragged Arrays

Classes and Objects 

General Form of a Class- Declaring Objects – Introducing Methods – Parameterized Methods-Method Overloading – Using Objects as Parameters - Constructors –  Parameterized Constructors - Constructor Overloading  – this keyword – Garbage collection -   Introducing Access Control – Understanding Static - Relationship Between Classes – Using Predefined Classes- Mutator and Accessor Methods

Lab Exercises:

1. Identify a domain of your choice, list out ten entities in the domain. For each entity, identify minimum 10 attributes and assign the data type for each attribute with proper justification.

2. Implement the concept of class, data members, member functions and access specifiers.

3. Implement the concept of array of objects with constructor and function overloading


Unit-2
Teaching Hours:18
INHERITANCE
 

Super Classes and Subclasses - Defining Subclasses – Overriding Methods- Dynamic Method Dispatch - Subclass constructors – Inheritance hierarchies- Polymorphism- Understanding method calls- Final Classes and Methods – Casting – Abstract Classes – Protected access – Object class. 

 

Packages and Interfaces

Defining a package - Finding packages and CLASSPATH – Packages and Member access –importing packages – Defining an interface – Implementing Interfaces – Accessing Implementation through interface references – Nested interfaces – Variables in interface – Extending interface –default methods, String and String Buffer class.

Lab Exercises:

4. Implement the concept of inheritance, super, abstract and final keywords.

5. Implement the concept of package and interface.

 

6. Implement the concept of String and String Buffer classes.

 

Unit-2
Teaching Hours:18
INHERITANCE
 

Super Classes and Subclasses - Defining Subclasses – Overriding Methods- Dynamic Method Dispatch - Subclass constructors – Inheritance hierarchies- Polymorphism- Understanding method calls- Final Classes and Methods – Casting – Abstract Classes – Protected access – Object class. 

 

Packages and Interfaces

Defining a package - Finding packages and CLASSPATH – Packages and Member access –importing packages – Defining an interface – Implementing Interfaces – Accessing Implementation through interface references – Nested interfaces – Variables in interface – Extending interface –default methods, String and String Buffer class.

Lab Exercises:

4. Implement the concept of inheritance, super, abstract and final keywords.

5. Implement the concept of package and interface.

 

6. Implement the concept of String and String Buffer classes.

 

Unit-2
Teaching Hours:18
INHERITANCE
 

Super Classes and Subclasses - Defining Subclasses – Overriding Methods- Dynamic Method Dispatch - Subclass constructors – Inheritance hierarchies- Polymorphism- Understanding method calls- Final Classes and Methods – Casting – Abstract Classes – Protected access – Object class. 

 

Packages and Interfaces

Defining a package - Finding packages and CLASSPATH – Packages and Member access –importing packages – Defining an interface – Implementing Interfaces – Accessing Implementation through interface references – Nested interfaces – Variables in interface – Extending interface –default methods, String and String Buffer class.

Lab Exercises:

4. Implement the concept of inheritance, super, abstract and final keywords.

5. Implement the concept of package and interface.

 

6. Implement the concept of String and String Buffer classes.

 

Unit-2
Teaching Hours:18
INHERITANCE
 

Super Classes and Subclasses - Defining Subclasses – Overriding Methods- Dynamic Method Dispatch - Subclass constructors – Inheritance hierarchies- Polymorphism- Understanding method calls- Final Classes and Methods – Casting – Abstract Classes – Protected access – Object class. 

 

Packages and Interfaces

Defining a package - Finding packages and CLASSPATH – Packages and Member access –importing packages – Defining an interface – Implementing Interfaces – Accessing Implementation through interface references – Nested interfaces – Variables in interface – Extending interface –default methods, String and String Buffer class.

Lab Exercises:

4. Implement the concept of inheritance, super, abstract and final keywords.

5. Implement the concept of package and interface.

 

6. Implement the concept of String and String Buffer classes.

 

Unit-3
Teaching Hours:18
EXCEPTION HANDLING, MULTI THREADING AND COLLECTIONS
 

Exception Handling 

Fundamentals – Exception types –uncaught exception – Using try and catch – Multiple catch clauses-  Nested try statements -  Throw – Throws - Finally  - Java’s Built in exception – Creating your own exception subclasses

 

Multi Threading

The java thread model – The Main thread -  Creating a thread – Creating multiple threads – Thread priorities – Synchronization – Inter - Thread communication.

 

Collections

Overview – Collection Interfaces (Collection – List – Set – SortedSet  – NavigableSet -  Queue– Deque)- Collection Classes(ArrayLsit – LinkedList – HashSet – LinkedHashSet-TreeSet- PriorityQueue- ArrayQueue-EnumSet)

Lab Exercises:

7. Implement the concept of Exception Handing in java.

8. Implement the concept of Multithreading

 

9. Implement the concept of collections

 

Unit-3
Teaching Hours:18
EXCEPTION HANDLING, MULTI THREADING AND COLLECTIONS
 

Exception Handling 

Fundamentals – Exception types –uncaught exception – Using try and catch – Multiple catch clauses-  Nested try statements -  Throw – Throws - Finally  - Java’s Built in exception – Creating your own exception subclasses

 

Multi Threading

The java thread model – The Main thread -  Creating a thread – Creating multiple threads – Thread priorities – Synchronization – Inter - Thread communication.

 

Collections

Overview – Collection Interfaces (Collection – List – Set – SortedSet  – NavigableSet -  Queue– Deque)- Collection Classes(ArrayLsit – LinkedList – HashSet – LinkedHashSet-TreeSet- PriorityQueue- ArrayQueue-EnumSet)

Lab Exercises:

7. Implement the concept of Exception Handing in java.

8. Implement the concept of Multithreading

 

9. Implement the concept of collections

 

Unit-3
Teaching Hours:18
EXCEPTION HANDLING, MULTI THREADING AND COLLECTIONS
 

Exception Handling 

Fundamentals – Exception types –uncaught exception – Using try and catch – Multiple catch clauses-  Nested try statements -  Throw – Throws - Finally  - Java’s Built in exception – Creating your own exception subclasses

 

Multi Threading

The java thread model – The Main thread -  Creating a thread – Creating multiple threads – Thread priorities – Synchronization – Inter - Thread communication.

 

Collections

Overview – Collection Interfaces (Collection – List – Set – SortedSet  – NavigableSet -  Queue– Deque)- Collection Classes(ArrayLsit – LinkedList – HashSet – LinkedHashSet-TreeSet- PriorityQueue- ArrayQueue-EnumSet)

Lab Exercises:

7. Implement the concept of Exception Handing in java.

8. Implement the concept of Multithreading

 

9. Implement the concept of collections

 

Unit-3
Teaching Hours:18
EXCEPTION HANDLING, MULTI THREADING AND COLLECTIONS
 

Exception Handling 

Fundamentals – Exception types –uncaught exception – Using try and catch – Multiple catch clauses-  Nested try statements -  Throw – Throws - Finally  - Java’s Built in exception – Creating your own exception subclasses

 

Multi Threading

The java thread model – The Main thread -  Creating a thread – Creating multiple threads – Thread priorities – Synchronization – Inter - Thread communication.

 

Collections

Overview – Collection Interfaces (Collection – List – Set – SortedSet  – NavigableSet -  Queue– Deque)- Collection Classes(ArrayLsit – LinkedList – HashSet – LinkedHashSet-TreeSet- PriorityQueue- ArrayQueue-EnumSet)

Lab Exercises:

7. Implement the concept of Exception Handing in java.

8. Implement the concept of Multithreading

 

9. Implement the concept of collections

 

Unit-4
Teaching Hours:18
SWING PACKAGE AND JDBC
 

Origin of swing – MVC connection- Components – Containers – Simple Swing Application- Event handling- JButton – JList – JTable – JcheckBox – JradioButton – JTextField – JComboBox- JScrollPane –JtoggleButton – JLabel – JTabbedPane – JTree – JMenuBar, JMenu – JmenuItem





Database

Database Programming – Connecting to and querying a database – Automatic driver recovery - Connecting to the database – Creating a Statement for executing query - Executing a query - Processing a Query’s ResultSet – PreparedStatements.

Lab Exercises:

10. Implement the concept of swing package

11. Implement the concept of JDBC

 

Unit-4
Teaching Hours:18
SWING PACKAGE AND JDBC
 

Origin of swing – MVC connection- Components – Containers – Simple Swing Application- Event handling- JButton – JList – JTable – JcheckBox – JradioButton – JTextField – JComboBox- JScrollPane –JtoggleButton – JLabel – JTabbedPane – JTree – JMenuBar, JMenu – JmenuItem





Database

Database Programming – Connecting to and querying a database – Automatic driver recovery - Connecting to the database – Creating a Statement for executing query - Executing a query - Processing a Query’s ResultSet – PreparedStatements.

Lab Exercises:

10. Implement the concept of swing package

11. Implement the concept of JDBC

 

Unit-4
Teaching Hours:18
SWING PACKAGE AND JDBC
 

Origin of swing – MVC connection- Components – Containers – Simple Swing Application- Event handling- JButton – JList – JTable – JcheckBox – JradioButton – JTextField – JComboBox- JScrollPane –JtoggleButton – JLabel – JTabbedPane – JTree – JMenuBar, JMenu – JmenuItem





Database

Database Programming – Connecting to and querying a database – Automatic driver recovery - Connecting to the database – Creating a Statement for executing query - Executing a query - Processing a Query’s ResultSet – PreparedStatements.

Lab Exercises:

10. Implement the concept of swing package

11. Implement the concept of JDBC

 

Unit-4
Teaching Hours:18
SWING PACKAGE AND JDBC
 

Origin of swing – MVC connection- Components – Containers – Simple Swing Application- Event handling- JButton – JList – JTable – JcheckBox – JradioButton – JTextField – JComboBox- JScrollPane –JtoggleButton – JLabel – JTabbedPane – JTree – JMenuBar, JMenu – JmenuItem





Database

Database Programming – Connecting to and querying a database – Automatic driver recovery - Connecting to the database – Creating a Statement for executing query - Executing a query - Processing a Query’s ResultSet – PreparedStatements.

Lab Exercises:

10. Implement the concept of swing package

11. Implement the concept of JDBC

 

Unit-5
Teaching Hours:18
JAVA SERVLETS & JSP
 

 JAVA SERVLETS

Servlets Basics – Life Cycle of a Servlet –A Simple Servlet - The Servlet API – Servlet Interfaces – Generic Servlet Class- HttpServletRequest Interface – HttpServeltResponse

JSP

The JSP development model – component of jsp page – Page directive – Action – scriptlet – JSP expression 

Lab Exercises:

12. Implement the concept of servlets

13. Implement the concept of JSP


Unit-5
Teaching Hours:18
JAVA SERVLETS & JSP
 

 JAVA SERVLETS

Servlets Basics – Life Cycle of a Servlet –A Simple Servlet - The Servlet API – Servlet Interfaces – Generic Servlet Class- HttpServletRequest Interface – HttpServeltResponse

JSP

The JSP development model – component of jsp page – Page directive – Action – scriptlet – JSP expression 

Lab Exercises:

12. Implement the concept of servlets

13. Implement the concept of JSP


Unit-5
Teaching Hours:18
JAVA SERVLETS & JSP
 

 JAVA SERVLETS

Servlets Basics – Life Cycle of a Servlet –A Simple Servlet - The Servlet API – Servlet Interfaces – Generic Servlet Class- HttpServletRequest Interface – HttpServeltResponse

JSP

The JSP development model – component of jsp page – Page directive – Action – scriptlet – JSP expression 

Lab Exercises:

12. Implement the concept of servlets

13. Implement the concept of JSP


Unit-5
Teaching Hours:18
JAVA SERVLETS & JSP
 

 JAVA SERVLETS

Servlets Basics – Life Cycle of a Servlet –A Simple Servlet - The Servlet API – Servlet Interfaces – Generic Servlet Class- HttpServletRequest Interface – HttpServeltResponse

JSP

The JSP development model – component of jsp page – Page directive – Action – scriptlet – JSP expression 

Lab Exercises:

12. Implement the concept of servlets

13. Implement the concept of JSP


Text Books And Reference Books:
  1. Schildt Herbert, Java :The Complete Reference, Tata McGraw- Hill, 11th Edition,2019

  2. The complete reference JSP 2.0, Tata McGraw- Hill, 2nd Edition, Phil Hanna

Essential Reading / Recommended Reading
  1. Horstmann Cay, Core Java volume 1-Fundamentals, 11th Edition, 2019

 

Web Resources:

 

  1. https://www.javatpoint.com/java-tutorial

  2. https://www.geeksforgeeks.org/java/

Evaluation Pattern

ESE 50%

CIA 50%

BCA261-2 - FULL STACK DEVELOPMENT (2024 Batch)

Total Teaching Hours for Semester:75
No of Lecture Hours/Week:5
Max Marks:100
Credits:3

Course Objectives/Course Description

 

This course gives an essence of web developer technologies and to develop web applications using in the most in-demand full stack development skills like HTML, CSS, JavaScript, React JS, jQuery and MySQL.

Learning Outcome

CO1: Develop front end application using HTML5, CSS3 and JavaScript along with jQuery and AngularJS framework.

CO2: Develop interactive web pages based on Bootstrap.

CO3: Implement MVC and responsive design to scale well across PC, tablet and Mobile Phone.

Unit-1
Teaching Hours:15
INTRODUCTION TO HTML
 

Basics of HTML, Elements, Attributes, Headings, Paragraph, styles, Formatting, Quotations, Computer Code, Comments & Colors, CSS, Links and Images, forms, Lists, Blocks, Classes, Layout, Responsive, iframes, JavaScript

Lab Exercises:

 

  1. Create a basic form with different elements.

  2. Develop a static page for a given scenario using HTML

Unit-1
Teaching Hours:15
INTRODUCTION TO HTML
 

Basics of HTML, Elements, Attributes, Headings, Paragraph, styles, Formatting, Quotations, Computer Code, Comments & Colors, CSS, Links and Images, forms, Lists, Blocks, Classes, Layout, Responsive, iframes, JavaScript

Lab Exercises:

 

  1. Create a basic form with different elements.

  2. Develop a static page for a given scenario using HTML

Unit-1
Teaching Hours:15
INTRODUCTION TO HTML
 

Basics of HTML, Elements, Attributes, Headings, Paragraph, styles, Formatting, Quotations, Computer Code, Comments & Colors, CSS, Links and Images, forms, Lists, Blocks, Classes, Layout, Responsive, iframes, JavaScript

Lab Exercises:

 

  1. Create a basic form with different elements.

  2. Develop a static page for a given scenario using HTML

Unit-1
Teaching Hours:15
INTRODUCTION TO HTML
 

Basics of HTML, Elements, Attributes, Headings, Paragraph, styles, Formatting, Quotations, Computer Code, Comments & Colors, CSS, Links and Images, forms, Lists, Blocks, Classes, Layout, Responsive, iframes, JavaScript

Lab Exercises:

 

  1. Create a basic form with different elements.

  2. Develop a static page for a given scenario using HTML

Unit-2
Teaching Hours:15
INTRODUCTION TO CSS3
 

Introduction to CSS3, Colours, Backgrounds, Boarders, Padding, Height/Width, Gradients, Shadows, Text, Fonts, 2D Transforms, 3D Transforms, Images, Animations, Buttons, Pagination, Multiple Columns, User Interface, Box Sizing, Filters, Media Queries, Responsive 

Lab Exercises:

1. Using CSS and HTML Make a webpage that has two columns. Each column should use half of the width of the page. The left half should have a light gray background and the right half should have a light green background. The left half should have a list of the 5 best-selling books, and the right should have a list of your five favorite celebrities or athletes.

 

2. Using an image, apply transformations and animations to make the image spin around endlessly.

Unit-2
Teaching Hours:15
INTRODUCTION TO CSS3
 

Introduction to CSS3, Colours, Backgrounds, Boarders, Padding, Height/Width, Gradients, Shadows, Text, Fonts, 2D Transforms, 3D Transforms, Images, Animations, Buttons, Pagination, Multiple Columns, User Interface, Box Sizing, Filters, Media Queries, Responsive 

Lab Exercises:

1. Using CSS and HTML Make a webpage that has two columns. Each column should use half of the width of the page. The left half should have a light gray background and the right half should have a light green background. The left half should have a list of the 5 best-selling books, and the right should have a list of your five favorite celebrities or athletes.

 

2. Using an image, apply transformations and animations to make the image spin around endlessly.

Unit-2
Teaching Hours:15
INTRODUCTION TO CSS3
 

Introduction to CSS3, Colours, Backgrounds, Boarders, Padding, Height/Width, Gradients, Shadows, Text, Fonts, 2D Transforms, 3D Transforms, Images, Animations, Buttons, Pagination, Multiple Columns, User Interface, Box Sizing, Filters, Media Queries, Responsive 

Lab Exercises:

1. Using CSS and HTML Make a webpage that has two columns. Each column should use half of the width of the page. The left half should have a light gray background and the right half should have a light green background. The left half should have a list of the 5 best-selling books, and the right should have a list of your five favorite celebrities or athletes.

 

2. Using an image, apply transformations and animations to make the image spin around endlessly.

Unit-2
Teaching Hours:15
INTRODUCTION TO CSS3
 

Introduction to CSS3, Colours, Backgrounds, Boarders, Padding, Height/Width, Gradients, Shadows, Text, Fonts, 2D Transforms, 3D Transforms, Images, Animations, Buttons, Pagination, Multiple Columns, User Interface, Box Sizing, Filters, Media Queries, Responsive 

Lab Exercises:

1. Using CSS and HTML Make a webpage that has two columns. Each column should use half of the width of the page. The left half should have a light gray background and the right half should have a light green background. The left half should have a list of the 5 best-selling books, and the right should have a list of your five favorite celebrities or athletes.

 

2. Using an image, apply transformations and animations to make the image spin around endlessly.

Unit-3
Teaching Hours:12
INTRODUCTION TO BOOTSTRAP AND JQUERY
 

Basics of Bootstrap, Grids, Themes, CSS, JS

Introduction to jQuery Syntax, Selectors, Events, Effects, HTML, Traversing, AJAX  

Lab Exercises:

1. Develop a responsive grid system using global CSS settings, extensive pre-built components including buttons, navbars, and form.

 

2. Convert the static webpage using jQuery to create sophisticated effects.

Unit-3
Teaching Hours:12
INTRODUCTION TO BOOTSTRAP AND JQUERY
 

Basics of Bootstrap, Grids, Themes, CSS, JS

Introduction to jQuery Syntax, Selectors, Events, Effects, HTML, Traversing, AJAX  

Lab Exercises:

1. Develop a responsive grid system using global CSS settings, extensive pre-built components including buttons, navbars, and form.

 

2. Convert the static webpage using jQuery to create sophisticated effects.

Unit-3
Teaching Hours:12
INTRODUCTION TO BOOTSTRAP AND JQUERY
 

Basics of Bootstrap, Grids, Themes, CSS, JS

Introduction to jQuery Syntax, Selectors, Events, Effects, HTML, Traversing, AJAX  

Lab Exercises:

1. Develop a responsive grid system using global CSS settings, extensive pre-built components including buttons, navbars, and form.

 

2. Convert the static webpage using jQuery to create sophisticated effects.

Unit-3
Teaching Hours:12
INTRODUCTION TO BOOTSTRAP AND JQUERY
 

Basics of Bootstrap, Grids, Themes, CSS, JS

Introduction to jQuery Syntax, Selectors, Events, Effects, HTML, Traversing, AJAX  

Lab Exercises:

1. Develop a responsive grid system using global CSS settings, extensive pre-built components including buttons, navbars, and form.

 

2. Convert the static webpage using jQuery to create sophisticated effects.

Unit-4
Teaching Hours:17
INTRODUCTION TO JAVASCRIPT
 

Introduction to JavaScript, Language Basics, Objects, Scope, Events, Strings, Numbers, Math, Arrays, Boolean, Comparisons, Conditions, Switch, Loops, Type Conversion, RegExp, Errors, Debugging, Hoisting, Strict Mode, Functions, Objects, Forms, HTML DOM, BOM

Lab Exercises:

1. Write a program to demonstrate the basic functionalities of JavaScript.

 

2. Develop a JavaScript code to describe the form validation and event handling.

Unit-4
Teaching Hours:17
INTRODUCTION TO JAVASCRIPT
 

Introduction to JavaScript, Language Basics, Objects, Scope, Events, Strings, Numbers, Math, Arrays, Boolean, Comparisons, Conditions, Switch, Loops, Type Conversion, RegExp, Errors, Debugging, Hoisting, Strict Mode, Functions, Objects, Forms, HTML DOM, BOM

Lab Exercises:

1. Write a program to demonstrate the basic functionalities of JavaScript.

 

2. Develop a JavaScript code to describe the form validation and event handling.

Unit-4
Teaching Hours:17
INTRODUCTION TO JAVASCRIPT
 

Introduction to JavaScript, Language Basics, Objects, Scope, Events, Strings, Numbers, Math, Arrays, Boolean, Comparisons, Conditions, Switch, Loops, Type Conversion, RegExp, Errors, Debugging, Hoisting, Strict Mode, Functions, Objects, Forms, HTML DOM, BOM

Lab Exercises:

1. Write a program to demonstrate the basic functionalities of JavaScript.

 

2. Develop a JavaScript code to describe the form validation and event handling.

Unit-4
Teaching Hours:17
INTRODUCTION TO JAVASCRIPT
 

Introduction to JavaScript, Language Basics, Objects, Scope, Events, Strings, Numbers, Math, Arrays, Boolean, Comparisons, Conditions, Switch, Loops, Type Conversion, RegExp, Errors, Debugging, Hoisting, Strict Mode, Functions, Objects, Forms, HTML DOM, BOM

Lab Exercises:

1. Write a program to demonstrate the basic functionalities of JavaScript.

 

2. Develop a JavaScript code to describe the form validation and event handling.

Unit-5
Teaching Hours:16
WORKING WITH DATABASE
 

Relational Database Concepts, how to design your database & web database architecture, creating databases and users, introduction to MySQL privilege system, setting up a user for the web, creating database tables, inserting, retrieving and updating data in to the database, altering tables after creation, checking and filtering input data, setting up a connection & querying the database.

Lab Exercises:

1. Build a code to demonstrate the functionalities of the queries in MySql.

2. Develop a webpage to authenticate the user to access another page with sessions.

Unit-5
Teaching Hours:16
WORKING WITH DATABASE
 

Relational Database Concepts, how to design your database & web database architecture, creating databases and users, introduction to MySQL privilege system, setting up a user for the web, creating database tables, inserting, retrieving and updating data in to the database, altering tables after creation, checking and filtering input data, setting up a connection & querying the database.

Lab Exercises:

1. Build a code to demonstrate the functionalities of the queries in MySql.

2. Develop a webpage to authenticate the user to access another page with sessions.

Unit-5
Teaching Hours:16
WORKING WITH DATABASE
 

Relational Database Concepts, how to design your database & web database architecture, creating databases and users, introduction to MySQL privilege system, setting up a user for the web, creating database tables, inserting, retrieving and updating data in to the database, altering tables after creation, checking and filtering input data, setting up a connection & querying the database.

Lab Exercises:

1. Build a code to demonstrate the functionalities of the queries in MySql.

2. Develop a webpage to authenticate the user to access another page with sessions.

Unit-5
Teaching Hours:16
WORKING WITH DATABASE
 

Relational Database Concepts, how to design your database & web database architecture, creating databases and users, introduction to MySQL privilege system, setting up a user for the web, creating database tables, inserting, retrieving and updating data in to the database, altering tables after creation, checking and filtering input data, setting up a connection & querying the database.

Lab Exercises:

1. Build a code to demonstrate the functionalities of the queries in MySql.

2. Develop a webpage to authenticate the user to access another page with sessions.

Text Books And Reference Books:

 

  1. HTML 5 Black Book (Covers CSS3, JavaScript, XML, XHTML, AJAX, PHP, jQuery), DT Editorial Services, Dreamtech Press, 2nd Edition, 2016.

  2. Chris Northwood, The Full Stack Developer: Your Essential Guide to the Everyday Skills Expected of a Modern Full Stack Web Developer, Apress Publications, 1st Edition, 2018.

  3. Laura Lemay, Rafe Colburn & Jennifer Kyrnin, Mastering HTML, CSS & Javascript Web Publishing, BPB Publications, 1st Edition, 2016.

Essential Reading / Recommended Reading

 

  1. Ben Frain, “Responsive Web Design with HTML5 and CSS”, 4th Edition, Pact Publishing, 2022.

  2. Larry Sanchez, “Web Programming with HTML, CSS, Bootstrap, JavaScript, JQuery, PHP, and MySQL”, 2nd Edition, Amazon Digital Services LLC, 2018.

  3. Stephen Burge, “MSQL Explained: Your Step-by-Step Guide to Database Design”, CreateSpace Independent Publishing Platform, 2017.

Evaluation Pattern

ESE - 50%

CIA - 50%

BCA101-3 - FINANCIAL ACCOUNTING (2023 Batch)

Total Teaching Hours for Semester:45
No of Lecture Hours/Week:3
Max Marks:100
Credits:3

Course Objectives/Course Description

 

The objective of this paper is to provide some basic knowledge about accounting concepts, conventions, and procedure to record the business transactions. This is also to give them an overall idea about how accounting standards are followed in recording and maintaining books of accounts. It helps them in reading and analysing the financial position of the company.

Learning Outcome

CO1: Demonstrate proficiency in recording business transactions by journalizing entries, posting to the ledger, and preparing a trial balance, using appropriate accounting principles

CO2: Analyze different types of cash books and transactions involving cash and trade discounts, solving problems related to the three-column cash book.

CO3: Prepare comprehensive final accounts, including adjustments, to evaluate a company's financial position and performance.

CO4: Evaluate the accuracy and completeness of accounting records by preparing and interpreting a trial balance, identifying and rectifying any discrepancies.

Unit-1
Teaching Hours:12
Introduction
 

Accounting Meaning, Need for accounting- Users of Accounting Information- Meaning of

Bookkeeping- Accounting principles- Accounting cycle-Phases of Accounting- Accounting

Equation Double Entry Meaning- Nature and Principles of Double Entry-Journal Meaning and Need- Steps in Journalizing- Problems

Unit-1
Teaching Hours:12
Introduction
 

Accounting Meaning, Need for accounting- Users of Accounting Information- Meaning of

Bookkeeping- Accounting principles- Accounting cycle-Phases of Accounting- Accounting

Equation Double Entry Meaning- Nature and Principles of Double Entry-Journal Meaning and Need- Steps in Journalizing- Problems

Unit-1
Teaching Hours:12
Introduction
 

Accounting Meaning, Need for accounting- Users of Accounting Information- Meaning of

Bookkeeping- Accounting principles- Accounting cycle-Phases of Accounting- Accounting

Equation Double Entry Meaning- Nature and Principles of Double Entry-Journal Meaning and Need- Steps in Journalizing- Problems

Unit-2
Teaching Hours:6
Ledger and Trial Balance
 

Ledger Meaning-Difference between Journal and Ledger-Steps in posting- Problems on Ledger

Trial Balance Meaning and objectives of preparing Trial Balance-Comprehensive problems on

Journal- Ledger and Trial Balance.

Unit-2
Teaching Hours:6
Ledger and Trial Balance
 

Ledger Meaning-Difference between Journal and Ledger-Steps in posting- Problems on Ledger

Trial Balance Meaning and objectives of preparing Trial Balance-Comprehensive problems on

Journal- Ledger and Trial Balance.

Unit-2
Teaching Hours:6
Ledger and Trial Balance
 

Ledger Meaning-Difference between Journal and Ledger-Steps in posting- Problems on Ledger

Trial Balance Meaning and objectives of preparing Trial Balance-Comprehensive problems on

Journal- Ledger and Trial Balance.

Unit-3
Teaching Hours:8
Cash book
 

Cash Book Meaning- objectives and classifications of cash book- Difference between cash discount and trade discount- Problems on Three column cash book

Unit-3
Teaching Hours:8
Cash book
 

Cash Book Meaning- objectives and classifications of cash book- Difference between cash discount and trade discount- Problems on Three column cash book

Unit-3
Teaching Hours:8
Cash book
 

Cash Book Meaning- objectives and classifications of cash book- Difference between cash discount and trade discount- Problems on Three column cash book

Unit-4
Teaching Hours:14
Final Accounts
 

Final Accounts Meaning- Need for preparation of Final Account- Components of Final

accounts-Problems with adjustments

Unit-4
Teaching Hours:14
Final Accounts
 

Final Accounts Meaning- Need for preparation of Final Account- Components of Final

accounts-Problems with adjustments

Unit-4
Teaching Hours:14
Final Accounts
 

Final Accounts Meaning- Need for preparation of Final Account- Components of Final

accounts-Problems with adjustments

Unit-5
Teaching Hours:5
Depreciation
 

Depreciation Meaning-Need for providing Depreciation-Problems on different methods of

Depreciation (Straight Line Method and Written Down Value Method)

Unit-5
Teaching Hours:5
Depreciation
 

Depreciation Meaning-Need for providing Depreciation-Problems on different methods of

Depreciation (Straight Line Method and Written Down Value Method)

Unit-5
Teaching Hours:5
Depreciation
 

Depreciation Meaning-Need for providing Depreciation-Problems on different methods of

Depreciation (Straight Line Method and Written Down Value Method)

Text Books And Reference Books:

Fundamentals of Accounting, Kalyani Publishers, S P Jain and K L Narang 2020

Essential Reading / Recommended Reading

1. Fundamentals of Accounting, Universal Publications, B S Raman, 2020

2. Accounting for Managers, Himalaya Publishing House, R Venkata Raman and Srinivas, 2020

3. S.N. Maheshwari & S.K. Gupta “Introduction to Accounting” 2020

Evaluation Pattern

CIAI = 20 marks, CIA II= 50 marks, CIA III = 20 marks, ESE = 100 marks (weightage, CIA = 50%, ESE = 50%) 

BCA181A-3 - FRENCH (2023 Batch)

Total Teaching Hours for Semester:30
No of Lecture Hours/Week:2
Max Marks:50
Credits:2

Course Objectives/Course Description

 

French as a second language in the UG program. The method< Adomania> consists of a student's book and an activity book, both included in the digital manual. It consists of 8 units. The structure of each unit begins with basic communication aspects, leading to basic expressions, vocabulary, cultural aspects, functional and practical French stage by stage in each unit.

Course Objectives   

  • To develop basic and communication skills sharpen oral and written skills.

  • To enhance knowledge on French culture. 

  • To enrich the learner’s vocabulary 

  • To enable learners to engage in and discuss simple topics with ease

Learning Outcome

CO1: Enhancement of communicative competencies and sharpening of written and oral communicative skills.

CO2: Basic knowledge of french civilization. Enrichment of vocabulary

CO3: Enhanced ability to engage in conversations and discussions in French with ease.

Unit-1
Teaching Hours:6
Étape 5 See you at the college
 

 

  • See you at the college.

  • Talking about life in college

  • Talk about our timetable

  • Vocabularies of college, months, seasons, timing etc.

  • Le verbe aller

  • Pourquoi/parce que

  • Les questions avec et quand

  • Il y a

Unit-1
Teaching Hours:6
Étape 5 See you at the college
 

 

  • See you at the college.

  • Talking about life in college

  • Talk about our timetable

  • Vocabularies of college, months, seasons, timing etc.

  • Le verbe aller

  • Pourquoi/parce que

  • Les questions avec et quand

  • Il y a

Unit-2
Teaching Hours:8
Fashion and us
 

 

  • Les adjectifs démonstratifs 

  • Le verbe pouvoir

  • Les articles indéfinis et définis 

  • La question avec quel(le)(s)

  • Talking about fashion

  • Talking about what we buy

  • Describe our style

  • Vocabularies of dress, accessories, numbers, purchase, style, appreciation etc.

Unit-2
Teaching Hours:8
Fashion and us
 

 

  • Les adjectifs démonstratifs 

  • Le verbe pouvoir

  • Les articles indéfinis et définis 

  • La question avec quel(le)(s)

  • Talking about fashion

  • Talking about what we buy

  • Describe our style

  • Vocabularies of dress, accessories, numbers, purchase, style, appreciation etc.

Unit-3
Teaching Hours:8
Étape 7 At our home
 

 

  • Describe our home

  • Organising our room

  • Talk about our daily activities 

  • Vocabularies of house, organisation, daily life etc.

  • Le verbe venir

  • Les préposition de lieu

  • L’impératif pour donner des conseils 

  • Chez+pronotonique

  • Les verbes pronominaux

Unit-3
Teaching Hours:8
Étape 7 At our home
 

 

  • Describe our home

  • Organising our room

  • Talk about our daily activities 

  • Vocabularies of house, organisation, daily life etc.

  • Le verbe venir

  • Les préposition de lieu

  • L’impératif pour donner des conseils 

  • Chez+pronotonique

  • Les verbes pronominaux

Unit-4
Teaching Hours:8
Étape 8
 

 

  • Talking about dream destinations

  • Making holiday plans

  • Telling the story of a trip

  • Vocabularies of countries, islands, capitals, continents, places, cacations, climate, etc.

  • Le verbe partir

  • Le futur proche

  • Les prépositions devant les noms de pays, d’îles et de villes

Unit-4
Teaching Hours:8
Étape 8
 

 

  • Talking about dream destinations

  • Making holiday plans

  • Telling the story of a trip

  • Vocabularies of countries, islands, capitals, continents, places, cacations, climate, etc.

  • Le verbe partir

  • Le futur proche

  • Les prépositions devant les noms de pays, d’îles et de villes

Text Books And Reference Books:

Berthet, Annie, Catherine Hugot et al. Alter Ego + A1. Paris : Hachette, 2012

Essential Reading / Recommended Reading

1.     French websites like Bonjour de France, Fluent U French, Learn French Lab, Point du FLE etc.

Evaluation Pattern

 

Assessment Pattern

CIA (Weight)

ESE (Weight)

CIA 1 – Assignments / Letter writing / Film review

10%

 

CIA 2 –Mid Sem Exam

25%

 

CIA 3 – Quiz / Role Play / Theatre / Creative projects  

10%

 

Attendance

05%

 

End Sem Exam

 

50%

Total

50%

50%

 

BCA181B-3 - GERMAN (2023 Batch)

Total Teaching Hours for Semester:30
No of Lecture Hours/Week:2
Max Marks:50
Credits:2

Course Objectives/Course Description

 

Course Description: This course mainly deals with the listening, speaking, writing, reading modules of basic German by using different pedagogies and effective strategies in order to meet the requirements of various situations. This course also enables the students to have cross-cultural competencies and cognitive skills.

 

Course Objectives: 

 

  • To achieve language proficiency skills on the medium level

  • To develop the skills demonstrated in the ability to interpret simple texts 

  • To attain some transcultural competency: an awareness of cross-cultural differences between societies.

  • To develop the ability to formulate questions

Learning Outcome

CO1: Understand and perform tasks in varied areas of social life with the help of the acquisition of communicative, linguistic and cultural know-how

CO2: Judge and do tasks in varied areas of day-to-day life activities

CO3: Formulate phrases related to personal details and particular concrete situations.

CO4: Recall the basic phrases and use them effectively

CO5: Interact and speak in small social gatherings.

Unit-1
Teaching Hours:8
Unit I
 

 

Alltag und Familie  : die Uhrzeit verstehen und nennen Zeitangaben machen über Familie sprechen | sich verabreden einen Termin telefonisch vereinbaren sich für eine Verspätung entschuldigen und darauf reagieren. Possessiveartikel: mein, dein,..,Zeitangaben mit am, um , von.....bis, Modalverben im Satz: Satzklammer, Modalverben müssen, können und  wollen.

Unit-1
Teaching Hours:8
Unit I
 

 

Alltag und Familie  : die Uhrzeit verstehen und nennen Zeitangaben machen über Familie sprechen | sich verabreden einen Termin telefonisch vereinbaren sich für eine Verspätung entschuldigen und darauf reagieren. Possessiveartikel: mein, dein,..,Zeitangaben mit am, um , von.....bis, Modalverben im Satz: Satzklammer, Modalverben müssen, können und  wollen.

Unit-2
Teaching Hours:8
Unit II
 

 

Zeit mit Freunden : eine Einladung verstehen und schreiben,etwas gemeinsam planen, im Restaurant bestellen und bezahlen,über ein Ereignis sprechen,über Geburtstage sprechen,bestimmte Informationen in Texten finden, Veranstaltungstipps im Radio verstehen. Präposition für + Akkusativ mich, dich ...,Datumsangaben: am ...., trennbare Verben. Präteritum von haben und sein.

Unit-2
Teaching Hours:8
Unit II
 

 

Zeit mit Freunden : eine Einladung verstehen und schreiben,etwas gemeinsam planen, im Restaurant bestellen und bezahlen,über ein Ereignis sprechen,über Geburtstage sprechen,bestimmte Informationen in Texten finden, Veranstaltungstipps im Radio verstehen. Präposition für + Akkusativ mich, dich ...,Datumsangaben: am ...., trennbare Verben. Präteritum von haben und sein.

Unit-3
Teaching Hours:7
Unit III
 

 

Arbeitsalltag: einen Blogbeitrag verstehen über den (Arbeits-)Alltag schreiben | Gespräche am Arbeitsplatz verstehen | Ortsangaben machen | Abläufe beschreiben | Briefe verstehen und beantworten Small Talk machen

Unit-3
Teaching Hours:7
Unit III
 

 

Arbeitsalltag: einen Blogbeitrag verstehen über den (Arbeits-)Alltag schreiben | Gespräche am Arbeitsplatz verstehen | Ortsangaben machen | Abläufe beschreiben | Briefe verstehen und beantworten Small Talk machen

Unit-4
Teaching Hours:7
Unit IV
 

Fit und gesund: Aufforderungen verstehen und ausdrücken | persönliche Angaben machen | Körperteile nennen Anweisungen wiedergeben | Gesundheitstipps verstehen. Gespräche beim Arzt führen | Anweisungen verstehen und geben | und geben. Korperteile Krankheiten | Medikamente |

                      Berufe im Krankenhaus. Imperativ mit du, ihr und Sie Imperativsätze | Modalverben: können, sollen, müssen, dürfen, wollen, möchten, mögen,  

 

                      Perfekt mit haben und sein     

Unit-4
Teaching Hours:7
Unit IV
 

Fit und gesund: Aufforderungen verstehen und ausdrücken | persönliche Angaben machen | Körperteile nennen Anweisungen wiedergeben | Gesundheitstipps verstehen. Gespräche beim Arzt führen | Anweisungen verstehen und geben | und geben. Korperteile Krankheiten | Medikamente |

                      Berufe im Krankenhaus. Imperativ mit du, ihr und Sie Imperativsätze | Modalverben: können, sollen, müssen, dürfen, wollen, möchten, mögen,  

 

                      Perfekt mit haben und sein     

Text Books And Reference Books:

Netzwerk neu Deutsch als Fremdsprache A1 Textbook, Workbook, Glossar and 2cds by Stefanie Dengler, Paul Rusch, Helen Schmitz, Tanja Sieber, Klett -Langenscheidt publishers

Essential Reading / Recommended Reading

 

  1. Studio d A1 set of three books and CD by Herr Mann Funk, Cornelsen publishers

  2. Deutsch Sprachlehre für Ausländer and Glossar Deutsch-English by Heinz Griesbach-Dora Schulz, Max Hueber publishers

  3. Deutsch für den Beruf text book by Adelheid h, Max Hueber publishers

  4. Deutsch für den Beruf work book by Adelheid h, Max Hueber publishers

  5. Grammatik intensiv trainer A1 Deutsch – Langenscheidt by Mark Lester, Larry Beason, Langenscheid publishers

  6. Fit für Goethe Zetifikat A1 start Deutsch 1 by Johaness Gerbes, Frau ke van der Werff, Hueber publishers

  7. Learn german through games and activities level1 Deutsch als Fremdsprache/Kursbuch und Arbeitsbuch and CD by Sabine Emmerich & Federica Colombo, eli publishers

Evaluation Pattern

 

Assessment Pattern

CIA (Weight)

ESE (Weight)

CIA 1 – Assignments / Creative Projects

10%

 

CIA 2 –Mid Semester Exam

25%

 

CIA 3 – Viva / Group assignment

10%

 

Attendance

05%

 

End Semester Exam

 

50%

Total

50%

50%

BCA201-3 - COMPUTER NETWORKS (2023 Batch)

Total Teaching Hours for Semester:60
No of Lecture Hours/Week:4
Max Marks:100
Credits:4

Course Objectives/Course Description

 

 

The goal of this course is to introduce the basics of computer networks. Students will learn their fundamental layered structure, understand common offered layered services, examine protocols and algorithms used to operate the network.

Learning Outcome

CO1: Gain knowledge about networks, internal components and its functionality.

CO2: Understand the Data communication concepts.

CO3: Trace and analyse any communication in network

CO4: Implement the networking concepts in real life scenarios.

Unit-2
Teaching Hours:11
Digital Transmission
 

Digital to digital conversion: Line coding – line coding schemes – block coding - Analog to digital conversion – PCM - transmission modes: serial transmission – parallel transmission.

Unit-2
Teaching Hours:11
Multiplexing
 

Frequency division multiplexing – Time division multiplexing.

 

Introduction to Transmission Media (Self Learning)

 

Unit-2
Teaching Hours:11
Analog Transmission
 

Digital to Analog conversion: FSK-ASK-PSK [ABR]Analog to Analog conversion.

Unit-2
Teaching Hours:11
Digital Transmission
 

Digital to digital conversion: Line coding – line coding schemes – block coding - Analog to digital conversion – PCM - transmission modes: serial transmission – parallel transmission.

Unit-2
Teaching Hours:11
Multiplexing
 

Frequency division multiplexing – Time division multiplexing.

 

Introduction to Transmission Media (Self Learning)

 

Unit-2
Teaching Hours:11
Analog Transmission
 

Digital to Analog conversion: FSK-ASK-PSK [ABR]Analog to Analog conversion.

Unit-2
Teaching Hours:11
Digital Transmission
 

Digital to digital conversion: Line coding – line coding schemes – block coding - Analog to digital conversion – PCM - transmission modes: serial transmission – parallel transmission.

Unit-2
Teaching Hours:11
Multiplexing
 

Frequency division multiplexing – Time division multiplexing.

 

Introduction to Transmission Media (Self Learning)

 

Unit-2
Teaching Hours:11
Analog Transmission
 

Digital to Analog conversion: FSK-ASK-PSK [ABR]Analog to Analog conversion.

Unit-3
Teaching Hours:12
Data Link Layer
 

 Introduction- block coding-linear block codes-cyclic codes-checksum, Hamming Code.

Unit-3
Teaching Hours:12
Data link Control
 

protocols-simplest protocol- stop and wait automatic repeat request--selective repeat-automatic repeat request-piggybacking.

Unit-3
Teaching Hours:12
Multiple Access
 

Random access-Aloha-CSMA-CSMA/CD-CSMA/CA Controlled access: reservation, polling, token passing. Channelization: FDMA, TDMA, CDMA.

Unit-3
Teaching Hours:12
Data Link Layer
 

 Introduction- block coding-linear block codes-cyclic codes-checksum, Hamming Code.

Unit-3
Teaching Hours:12
Data link Control
 

protocols-simplest protocol- stop and wait automatic repeat request--selective repeat-automatic repeat request-piggybacking.

Unit-3
Teaching Hours:12
Multiple Access
 

Random access-Aloha-CSMA-CSMA/CD-CSMA/CA Controlled access: reservation, polling, token passing. Channelization: FDMA, TDMA, CDMA.

Unit-3
Teaching Hours:12
Data Link Layer
 

 Introduction- block coding-linear block codes-cyclic codes-checksum, Hamming Code.

Unit-3
Teaching Hours:12
Data link Control
 

protocols-simplest protocol- stop and wait automatic repeat request--selective repeat-automatic repeat request-piggybacking.

Unit-3
Teaching Hours:12
Multiple Access
 

Random access-Aloha-CSMA-CSMA/CD-CSMA/CA Controlled access: reservation, polling, token passing. Channelization: FDMA, TDMA, CDMA.

Unit-4
Teaching Hours:12
Wired LANs
 

Ethernet: IEEE standards, standard Ethernet- fast Ethernet.

Unit-4
Teaching Hours:12
Wireless Lans
 

IEEE 802.11-arhitecture-MAC sublayers, physical layer.

Unit-4
Teaching Hours:12
Network Layer
 

Addressing: IPV4 addresses - IPV6 Addresses Internet Protocol: IPv4 –IPv6 Address mapping protocols: ARP – RARP.

Unit-4
Teaching Hours:12
Wired LANs
 

Ethernet: IEEE standards, standard Ethernet- fast Ethernet.

Unit-4
Teaching Hours:12
Wireless Lans
 

IEEE 802.11-arhitecture-MAC sublayers, physical layer.

Unit-4
Teaching Hours:12
Network Layer
 

Addressing: IPV4 addresses - IPV6 Addresses Internet Protocol: IPv4 –IPv6 Address mapping protocols: ARP – RARP.

Unit-4
Teaching Hours:12
Wired LANs
 

Ethernet: IEEE standards, standard Ethernet- fast Ethernet.

Unit-4
Teaching Hours:12
Wireless Lans
 

IEEE 802.11-arhitecture-MAC sublayers, physical layer.

Unit-4
Teaching Hours:12
Network Layer
 

Addressing: IPV4 addresses - IPV6 Addresses Internet Protocol: IPv4 –IPv6 Address mapping protocols: ARP – RARP.

Unit-5
Teaching Hours:13
Network Layer and Transport Layer
 

Routing protocols: Unicast routing protocols: distance vector routing, Link State routing Multicast Routing protocols. Transport Layer: Process to process delivery – UDP – TCP Congestion control: Data traffic – congestion – congestion control.

 

Unit-5
Teaching Hours:13
Application layer
 

Overview of Name space, DNS, FILE transfer: FTP, WWW and HTTP: Architecture – web documents – HTTP, Cryptography: Introduction - definitions – two categories - symmetric key cryptography – traditional ciphers – asymmetric key cryptography.

Unit-5
Teaching Hours:13
Network Layer and Transport Layer
 

Routing protocols: Unicast routing protocols: distance vector routing, Link State routing Multicast Routing protocols. Transport Layer: Process to process delivery – UDP – TCP Congestion control: Data traffic – congestion – congestion control.

 

Unit-5
Teaching Hours:13
Application layer
 

Overview of Name space, DNS, FILE transfer: FTP, WWW and HTTP: Architecture – web documents – HTTP, Cryptography: Introduction - definitions – two categories - symmetric key cryptography – traditional ciphers – asymmetric key cryptography.

Unit-5
Teaching Hours:13
Network Layer and Transport Layer
 

Routing protocols: Unicast routing protocols: distance vector routing, Link State routing Multicast Routing protocols. Transport Layer: Process to process delivery – UDP – TCP Congestion control: Data traffic – congestion – congestion control.

 

Unit-5
Teaching Hours:13
Application layer
 

Overview of Name space, DNS, FILE transfer: FTP, WWW and HTTP: Architecture – web documents – HTTP, Cryptography: Introduction - definitions – two categories - symmetric key cryptography – traditional ciphers – asymmetric key cryptography.

Text Books And Reference Books:
  1. Behrouz A Forouzan, Data communication and networking, McGraw-Hill, 5thedition, 2017.
  2. Andrew S Tanenbaum, Computer Networks, PHI publications, 5thedition, 2022.
Essential Reading / Recommended Reading
  1. Andrew S Tanenbaum, Computer Networks, PHI publications, 5thedition, 2022.
  2. Mike Meyers, CompTIA Network+, 7th Edition, McGrawHill Publications, 2018.
  3. James Kurose, Computer Networking: A Top-Down Approach, Pearson Publications, Global Edition, 2021.

 

Evaluation Pattern

CIA 50%

ESE 50%

 

BCA202-3 - OPERATING SYSTEM (2023 Batch)

Total Teaching Hours for Semester:45
No of Lecture Hours/Week:3
Max Marks:100
Credits:3

Course Objectives/Course Description

 

This course is an introduction to the concepts behind modern computer operating systems. Topics will include what an operating system does (and doesn't) do- system calls and interfaces- processes- resource scheduling and management (of the CPU- memory- etc.)- Virtual memory. To acquire the fundamental knowledge of the operating system architecture and its components.

Learning Outcome

CO1: Demonstrate an understanding of the basic working process of an operating system.

CO2: Explain the importance of process and scheduling.

CO3: Analyse the issues in synchronization and memory management.

Unit-1
Teaching Hours:9
Introduction
 

Categories of Operating Systems- Computer-System Organization- Computer-System Architecture- Operating-System Structure- Operating-System Operations. 

Unit-1
Teaching Hours:9
System Structures
 

Operating-System Services- User Operating-System Interface- System Calls- Types of System Calls- System Programs. 

Unit-1
Teaching Hours:9
Process Management
 

Process Concept- Process Scheduling- Operations on Processes: process creation and termination - zombie and orphan process- Cooperating Processes- Inter-process Communication- Process related commands.

Unit-1
Teaching Hours:9
Introduction
 

Categories of Operating Systems- Computer-System Organization- Computer-System Architecture- Operating-System Structure- Operating-System Operations. 

Unit-1
Teaching Hours:9
System Structures
 

Operating-System Services- User Operating-System Interface- System Calls- Types of System Calls- System Programs. 

Unit-1
Teaching Hours:9
Process Management
 

Process Concept- Process Scheduling- Operations on Processes: process creation and termination - zombie and orphan process- Cooperating Processes- Inter-process Communication- Process related commands.

Unit-1
Teaching Hours:9
Introduction
 

Categories of Operating Systems- Computer-System Organization- Computer-System Architecture- Operating-System Structure- Operating-System Operations. 

Unit-1
Teaching Hours:9
System Structures
 

Operating-System Services- User Operating-System Interface- System Calls- Types of System Calls- System Programs. 

Unit-1
Teaching Hours:9
Process Management
 

Process Concept- Process Scheduling- Operations on Processes: process creation and termination - zombie and orphan process- Cooperating Processes- Inter-process Communication- Process related commands.

Unit-2
Teaching Hours:9
Scheduling and Synchronization
 

CPU Scheduling- Basic Concepts- Scheduling Criteria- Scheduling Algorithms- Thread Scheduling- Multiple-Processor Scheduling - The Critical-Section Problem - Peterson’s Solution - Synchronization Hardware - Semaphores - Classic problems of Synchronization - Multithreading models - threading issues. 

Unit-2
Teaching Hours:9
Scheduling and Synchronization
 

CPU Scheduling- Basic Concepts- Scheduling Criteria- Scheduling Algorithms- Thread Scheduling- Multiple-Processor Scheduling - The Critical-Section Problem - Peterson’s Solution - Synchronization Hardware - Semaphores - Classic problems of Synchronization - Multithreading models - threading issues. 

Unit-2
Teaching Hours:9
Scheduling and Synchronization
 

CPU Scheduling- Basic Concepts- Scheduling Criteria- Scheduling Algorithms- Thread Scheduling- Multiple-Processor Scheduling - The Critical-Section Problem - Peterson’s Solution - Synchronization Hardware - Semaphores - Classic problems of Synchronization - Multithreading models - threading issues. 

Unit-3
Teaching Hours:10
Memory Management Strategies and Deadlocks
 

System Model- Deadlock Characterization- Methods for handling Deadlocks, Deadlock Prevention- Deadlock avoidance- Deadlock detection- Recovery from Deadlocks – Swapping- Contiguous Memory allocation- Paging- Structure of the Page Table- Segmentation. 

Unit-3
Teaching Hours:10
Memory Management Strategies and Deadlocks
 

System Model- Deadlock Characterization- Methods for handling Deadlocks, Deadlock Prevention- Deadlock avoidance- Deadlock detection- Recovery from Deadlocks – Swapping- Contiguous Memory allocation- Paging- Structure of the Page Table- Segmentation. 

Unit-3
Teaching Hours:10
Memory Management Strategies and Deadlocks
 

System Model- Deadlock Characterization- Methods for handling Deadlocks, Deadlock Prevention- Deadlock avoidance- Deadlock detection- Recovery from Deadlocks – Swapping- Contiguous Memory allocation- Paging- Structure of the Page Table- Segmentation. 

Unit-4
Teaching Hours:9
Virtual Memory Management
 

Demand Paging- Copy-on-Write- Page Replacement- page replacement algorithms- Allocation of frames- Thrashing.

Unit-4
Teaching Hours:9
File System
 

 File Concept- Access Methods- Directory and Disk Structure- File System Mounting- File Sharing- Protection. 

Unit-4
Teaching Hours:9
Virtual Memory Management
 

Demand Paging- Copy-on-Write- Page Replacement- page replacement algorithms- Allocation of frames- Thrashing.

Unit-4
Teaching Hours:9
File System
 

 File Concept- Access Methods- Directory and Disk Structure- File System Mounting- File Sharing- Protection. 

Unit-4
Teaching Hours:9
Virtual Memory Management
 

Demand Paging- Copy-on-Write- Page Replacement- page replacement algorithms- Allocation of frames- Thrashing.

Unit-4
Teaching Hours:9
File System
 

 File Concept- Access Methods- Directory and Disk Structure- File System Mounting- File Sharing- Protection. 

Unit-5
Teaching Hours:8
Implementing File Systems
 

File System Structure- File System Implementation- Directory Implementation- allocation Methods- Free-space Management. 

Unit-5
Teaching Hours:8
Secondary Storage Structure
 

Disk Structure- Disk Attachment- Disk Scheduling- Disk Management and Swap-Space Management. Case study. 

Unit-5
Teaching Hours:8
Implementing File Systems
 

File System Structure- File System Implementation- Directory Implementation- allocation Methods- Free-space Management. 

Unit-5
Teaching Hours:8
Secondary Storage Structure
 

Disk Structure- Disk Attachment- Disk Scheduling- Disk Management and Swap-Space Management. Case study. 

Unit-5
Teaching Hours:8
Implementing File Systems
 

File System Structure- File System Implementation- Directory Implementation- allocation Methods- Free-space Management. 

Unit-5
Teaching Hours:8
Secondary Storage Structure
 

Disk Structure- Disk Attachment- Disk Scheduling- Disk Management and Swap-Space Management. Case study. 

Text Books And Reference Books:
  1. Silberschatz- P.B. Galvin and G. Gagne- Operating System Concepts.9th Edition- New Delhi: Wiley India- 2011. 
  2. A/S. Tanenbaum, Modern Operating Systems, 3rd Ed., Prentice Hall, 2007.
Essential Reading / Recommended Reading
  1. Stalling William- Operating Systems: Internals and Design Principles. 7th Edition - Prentice Hall-2011.
  2. Dietel et al., Operating System, 3rd Edition, Pearson Education, 2004.
Evaluation Pattern

ESE - 50%

CIA - 50%

BCA263-3 - INTRODUCTION TO PYTHON (2023 Batch)

Total Teaching Hours for Semester:60
No of Lecture Hours/Week:4
Max Marks:100
Credits:3

Course Objectives/Course Description

 

This course covers the basic programming paradigms associated with Python.

 

Learning Outcome

CO1: Understand Python Environment and its Data structures

CO2: Apply Programming logics using Control statements and functions

CO3: Build applications using python modules

Unit-1
Teaching Hours:12
INTRODUCING PYTHON
 

Introduction, Python Fundamentals, Features of Python, Components of a Python Program, Understanding the interpreter.

Unit-1
Teaching Hours:12
PYTHON BASICS
 

Identifiers, Basic Types, Operators, Precedence and Associativity, Decision Control Structures, Looping Structures, Console input, output.

Unit-1
Teaching Hours:12
Practicals
 

1. Implement Basic data types and operators

2. Apply Decision Making and Looping concepts

 

Unit-1
Teaching Hours:12
INTRODUCING PYTHON
 

Introduction, Python Fundamentals, Features of Python, Components of a Python Program, Understanding the interpreter.

Unit-1
Teaching Hours:12
PYTHON BASICS
 

Identifiers, Basic Types, Operators, Precedence and Associativity, Decision Control Structures, Looping Structures, Console input, output.

Unit-1
Teaching Hours:12
Practicals
 

1. Implement Basic data types and operators

2. Apply Decision Making and Looping concepts

 

Unit-1
Teaching Hours:12
INTRODUCING PYTHON
 

Introduction, Python Fundamentals, Features of Python, Components of a Python Program, Understanding the interpreter.

Unit-1
Teaching Hours:12
PYTHON BASICS
 

Identifiers, Basic Types, Operators, Precedence and Associativity, Decision Control Structures, Looping Structures, Console input, output.

Unit-1
Teaching Hours:12
Practicals
 

1. Implement Basic data types and operators

2. Apply Decision Making and Looping concepts

 

Unit-2
Teaching Hours:12
PYTHON DATA TYPES: LISTS AND TUPLES
 

Lists: Accessing elements, Basic List operations, Built-in methods

Tuples: working with elements, Basic Tuple operation, Tuple methods and Type of Tuples.

Unit-2
Teaching Hours:12
Practicals
 

3. Implement List

4. Implement Tuples

 

Unit-2
Teaching Hours:12
PYTHON DATA TYPES: LISTS AND TUPLES
 

Lists: Accessing elements, Basic List operations, Built-in methods

Tuples: working with elements, Basic Tuple operation, Tuple methods and Type of Tuples.

Unit-2
Teaching Hours:12
Practicals
 

3. Implement List

4. Implement Tuples

 

Unit-2
Teaching Hours:12
PYTHON DATA TYPES: LISTS AND TUPLES
 

Lists: Accessing elements, Basic List operations, Built-in methods

Tuples: working with elements, Basic Tuple operation, Tuple methods and Type of Tuples.

Unit-2
Teaching Hours:12
Practicals
 

3. Implement List

4. Implement Tuples

 

Unit-3
Teaching Hours:12
PYTHON DATA TYPES: SETS AND DICTIONARIES
 

Sets: Definition, Set Elements, Built-in methods, basic set operations, Mathematical Set operation, Variety of Sets. 

Dictionaries:  Defining a dictionary, accessing elements, basic operations, methods

Unit-3
Teaching Hours:12
Practical
 

5. Implement Dictionary

6. Implement Set

 

Unit-3
Teaching Hours:12
PYTHON DATA TYPES: SETS AND DICTIONARIES
 

Sets: Definition, Set Elements, Built-in methods, basic set operations, Mathematical Set operation, Variety of Sets. 

Dictionaries:  Defining a dictionary, accessing elements, basic operations, methods

Unit-3
Teaching Hours:12
Practical
 

5. Implement Dictionary

6. Implement Set

 

Unit-3
Teaching Hours:12
PYTHON DATA TYPES: SETS AND DICTIONARIES
 

Sets: Definition, Set Elements, Built-in methods, basic set operations, Mathematical Set operation, Variety of Sets. 

Dictionaries:  Defining a dictionary, accessing elements, basic operations, methods

Unit-3
Teaching Hours:12
Practical
 

5. Implement Dictionary

6. Implement Set

 

Unit-4
Teaching Hours:12
COMPREHENSIONS AND FUNCTIONS
 

Comprehensions: List Comprehensions, Set Comprehension, Dictionary Comprehension.

Functions: Defining a function, Types of arguments, unpacking arguments.

Recursive functions.

Unit-4
Teaching Hours:12
Practicals
 

7. Implement List, Set and Dictionary Comprehensions

8. Implement Recursive function

 

Unit-4
Teaching Hours:12
COMPREHENSIONS AND FUNCTIONS
 

Comprehensions: List Comprehensions, Set Comprehension, Dictionary Comprehension.

Functions: Defining a function, Types of arguments, unpacking arguments.

Recursive functions.

Unit-4
Teaching Hours:12
Practicals
 

7. Implement List, Set and Dictionary Comprehensions

8. Implement Recursive function

 

Unit-4
Teaching Hours:12
COMPREHENSIONS AND FUNCTIONS
 

Comprehensions: List Comprehensions, Set Comprehension, Dictionary Comprehension.

Functions: Defining a function, Types of arguments, unpacking arguments.

Recursive functions.

Unit-4
Teaching Hours:12
Practicals
 

7. Implement List, Set and Dictionary Comprehensions

8. Implement Recursive function

 

Unit-5
Teaching Hours:12
FUNCTIONAL PROGRAMMING
 

Lambda functions, Higher order functions, Map, Filter, Reduce, Using Lambda with map(),filter(),reduce().

Unit-5
Teaching Hours:12
MODULES, PACKAGES AND NAMESPACES
 

Main module, built-in, creation of user defined modules , importing a module, packages ,Namespace.

Unit-5
Teaching Hours:12
Practical
 

9. Implement Lambda function using map(), filter(),reduce().

10. Implement custom module

 

Unit-5
Teaching Hours:12
FUNCTIONAL PROGRAMMING
 

Lambda functions, Higher order functions, Map, Filter, Reduce, Using Lambda with map(),filter(),reduce().

Unit-5
Teaching Hours:12
MODULES, PACKAGES AND NAMESPACES
 

Main module, built-in, creation of user defined modules , importing a module, packages ,Namespace.

Unit-5
Teaching Hours:12
Practical
 

9. Implement Lambda function using map(), filter(),reduce().

10. Implement custom module

 

Unit-5
Teaching Hours:12
FUNCTIONAL PROGRAMMING
 

Lambda functions, Higher order functions, Map, Filter, Reduce, Using Lambda with map(),filter(),reduce().

Unit-5
Teaching Hours:12
MODULES, PACKAGES AND NAMESPACES
 

Main module, built-in, creation of user defined modules , importing a module, packages ,Namespace.

Unit-5
Teaching Hours:12
Practical
 

9. Implement Lambda function using map(), filter(),reduce().

10. Implement custom module

 

Text Books And Reference Books:

[1] Martin Brown, Python:The Complete Reference,  McGraw Hill Publications,4th  Edition March 2018.

[2] Yashavant Kanetkar,Aditya Kanetkar, Let Us Python, BPB Publications ,4th Edition 2022.

Essential Reading / Recommended Reading

[1] Zhang.Y ,An Introduction to Python and Computer Programming, Springer Publications,2016

Evaluation Pattern

CIA -50%

ESE- 50%

BCA281-3 - SUMMER INTERNSHIP (2023 Batch)

Total Teaching Hours for Semester:60
No of Lecture Hours/Week:4
Max Marks:100
Credits:4

Course Objectives/Course Description

 

The Department of Computer Science offers a specialized summer internship tailored for first-year undergraduate students, spanning a duration of 4 weeks. This intensive program is designed to immerse participants in hands-on experiences encompassing computer science and application. Students will engage in practical projects and theoretical exploration under the guidance of faculty mentors, fostering a deep understanding of foundational concepts and their real-world applications. Through collaborative research, programming exercises, and data analysis tasks, interns will develop critical skills in problem-solving, algorithmic thinking, and quantitative reasoning. By the end of the internship, participants will have gained valuable insights and experience to prepare them for further academic pursuits and future careers in technology and related fields.

Learning Outcome

CO1: Provide students with a foundational understanding of key principles in computer science and its applications(in any field) through interactive sessions

CO2: Engage students in practical,participatory/experiential/project-based learning to apply theoretical knowledge to real-world problems, enhancing their programming skills and algorithmic thinking.

Unit-1
Teaching Hours:60
Summer Internship
 

NA

Unit-1
Teaching Hours:60
Summer Internship
 

NA

Unit-1
Teaching Hours:60
Summer Internship
 

NA

Text Books And Reference Books:

NIL

Essential Reading / Recommended Reading

NIL

Evaluation Pattern

CIA - 50%

ESE- 50%

BCA301-3 - MOBILE APPLICATIONS (2023 Batch)

Total Teaching Hours for Semester:75
No of Lecture Hours/Week:5
Max Marks:100
Credits:4

Course Objectives/Course Description

 

 

Students will be able to build up an environment for developing Android applications, construct user-friendly user interfaces, manage many tasks, develop persistent applications, handle cloud data, test their apps, and release them onto the market with the help of this course.

Learning Outcome

CO1: Demonstrate an understanding of enterprise level mobile applications with Kotlin on Android

CO2: Apply the basic and advanced concepts of Mobile application development

CO3: Design and develop user interfaces for the Android platforms

CO4: Deploy the application on Google Play

Unit-1
Teaching Hours:15
INTRODUCTION TO ANDROID
 

History of Mobile Apps, Trends in Market - Web App Vs Mobile App - Mobile OS. Introduction to  Android and Kotlin: Kotlin Basics – variables - Functions. First Android App – Setup Android Studio - Deploying the app: Running and Debugging app in Android Emulator.

Lab Exercises:

  1. Display Text and Image.

  2. Implement Functions.

Unit-1
Teaching Hours:15
INTRODUCTION TO ANDROID
 

History of Mobile Apps, Trends in Market - Web App Vs Mobile App - Mobile OS. Introduction to  Android and Kotlin: Kotlin Basics – variables - Functions. First Android App – Setup Android Studio - Deploying the app: Running and Debugging app in Android Emulator.

Lab Exercises:

  1. Display Text and Image.

  2. Implement Functions.

Unit-1
Teaching Hours:15
INTRODUCTION TO ANDROID
 

History of Mobile Apps, Trends in Market - Web App Vs Mobile App - Mobile OS. Introduction to  Android and Kotlin: Kotlin Basics – variables - Functions. First Android App – Setup Android Studio - Deploying the app: Running and Debugging app in Android Emulator.

Lab Exercises:

  1. Display Text and Image.

  2. Implement Functions.

Unit-2
Teaching Hours:15
LAYOUT AND ACTIVITY
 

Kotlin Fundamentals: Classes and Objects - Inheritance. Activity: Introduction to Activity - Activity Lifecycle – Logging. Layouts in Android - Types of Layouts, Multiple activities and Intents.

Lab Exercises:

3. Intents

 

4. Activity Lifecycle

Unit-2
Teaching Hours:15
LAYOUT AND ACTIVITY
 

Kotlin Fundamentals: Classes and Objects - Inheritance. Activity: Introduction to Activity - Activity Lifecycle – Logging. Layouts in Android - Types of Layouts, Multiple activities and Intents.

Lab Exercises:

3. Intents

 

4. Activity Lifecycle

Unit-2
Teaching Hours:15
LAYOUT AND ACTIVITY
 

Kotlin Fundamentals: Classes and Objects - Inheritance. Activity: Introduction to Activity - Activity Lifecycle – Logging. Layouts in Android - Types of Layouts, Multiple activities and Intents.

Lab Exercises:

3. Intents

 

4. Activity Lifecycle

Unit-3
Teaching Hours:15
VIEWS
 

Using Basic Views-Using Picker Views -Using List Views to Display Long Lists- Using Image Views to Display Pictures. Menus -  Types of Menus.

Lab Exercises:

5. Input Controls and Image Views

 

6. Menu Implementation.

Unit-3
Teaching Hours:15
VIEWS
 

Using Basic Views-Using Picker Views -Using List Views to Display Long Lists- Using Image Views to Display Pictures. Menus -  Types of Menus.

Lab Exercises:

5. Input Controls and Image Views

 

6. Menu Implementation.

Unit-3
Teaching Hours:15
VIEWS
 

Using Basic Views-Using Picker Views -Using List Views to Display Long Lists- Using Image Views to Display Pictures. Menus -  Types of Menus.

Lab Exercises:

5. Input Controls and Image Views

 

6. Menu Implementation.

Unit-4
Teaching Hours:15
NAVIGATION AND FRAGMENT
 

Navigation in an app - Navigation UI - navigation drawer.  Fragments: Introduction - Lifecycle- Task and Back Stack. Android App Architecture - View Model - Data Binding – Live Data- Transform Live Data.

 

Lab Exercises:

7. User navigation 

 

8. Fragment Lifecycle

 

Unit-4
Teaching Hours:15
NAVIGATION AND FRAGMENT
 

Navigation in an app - Navigation UI - navigation drawer.  Fragments: Introduction - Lifecycle- Task and Back Stack. Android App Architecture - View Model - Data Binding – Live Data- Transform Live Data.

 

Lab Exercises:

7. User navigation 

 

8. Fragment Lifecycle

 

Unit-4
Teaching Hours:15
NAVIGATION AND FRAGMENT
 

Navigation in an app - Navigation UI - navigation drawer.  Fragments: Introduction - Lifecycle- Task and Back Stack. Android App Architecture - View Model - Data Binding – Live Data- Transform Live Data.

 

Lab Exercises:

7. User navigation 

 

8. Fragment Lifecycle

 

Unit-5
Teaching Hours:15
SAVING USER DATA
 

Displaying lists with RecyclerView. Store Data-Room Persistency Library-Asynchronous program-Coroutines-Testing Databases. 

 

Lab Exercises:

9. Recyclerview

 

10. Sharedpreference

 

Unit-5
Teaching Hours:15
SAVING USER DATA
 

Displaying lists with RecyclerView. Store Data-Room Persistency Library-Asynchronous program-Coroutines-Testing Databases. 

 

Lab Exercises:

9. Recyclerview

 

10. Sharedpreference

 

Unit-5
Teaching Hours:15
SAVING USER DATA
 

Displaying lists with RecyclerView. Store Data-Room Persistency Library-Asynchronous program-Coroutines-Testing Databases. 

 

Lab Exercises:

9. Recyclerview

 

10. Sharedpreference

 

Text Books And Reference Books:

 

  1. Griffiths, Dawn, and Griffiths, David. Head First Android Development. United States, O'Reilly Media, 2021.

  2. Kotlin for Android App Development.Sommerhoff, P. United Kingdom: Pearson Education 2018.

Essential Reading / Recommended Reading

 

  1. How to Build Android Apps with Kotlin: A Practical Guide to Developing, Testing and Publishing Your First Android Apps. Forrester, A., Boudjnah, E., Dumbravan, A., Tigcal, J. United Kingdom: Packt Publishing 2023.

  2. Nagy, Robert. Simplifying Application Development with Kotlin Multiplatform Mobile: Write Robust Native Applications for IOS and Android Efficiently. United Kingdom, Packt Publishing, 2022.

Evaluation Pattern

CIA 50%

ESE 50%

BCA181A-4 - FRENCH (2023 Batch)

Total Teaching Hours for Semester:30
No of Lecture Hours/Week:2
Max Marks:50
Credits:2

Course Objectives/Course Description

 

Course Description -French as a second language in the UG program. The method< Adomania> consists of a student's book and an activity book, both included in the digital manual. It consists of 8 units. The structure of each unit begins with basic communication aspects, leading to basic expressions, vocabulary, cultural aspects, functional and practical French stage by stage in each unit. This< manual> covers all the necessary global parameters.

 

Course Objectives

  • To develop basic and communication skills sharpen oral and written skills.
  • To enhance knowledge on French culture.
  • To enrich the learner’s vocabulary
  • To enable learners to engage in and discuss simple topics with ease

Learning Outcome

CO1: Enhancement of communicative competencies and sharpening of written and oral communicative skills.

CO2: Basic knowledge of french civilization. Enrichment of vocabulary

CO3: Enhanced ability to engage in conversations and discussions in French with ease.

Unit-1
Teaching Hours:6
Étape 5 See you at the college
 

          See you at the college.

          Talking about life in college

          Talk about our timetable

Vocabularies of college, months, seasons, timing etc.

 

          Le verbe aller

          Pourquoi/parce que

          Les questions avec et quand

          Il y a

Unit-1
Teaching Hours:6
Étape 5 See you at the college
 

          See you at the college.

          Talking about life in college

          Talk about our timetable

Vocabularies of college, months, seasons, timing etc.

 

          Le verbe aller

          Pourquoi/parce que

          Les questions avec et quand

          Il y a

Unit-2
Teaching Hours:8
Étape 6 Fashion and us
 

          Talking about fashion

 

          Talking about what we buy

 

          Describe our style

Vocabularies of dress, accessories, numbers, purchase, style, appreciation etc.

          Les adjectifs démonstratifs

          Le verbe pouvoir

          Les articles indéfinis et définis

La question avec quel(le)(s) 

  • Talking about fashion

  • Talking about what we buy

  • Describe our style

  • Vocabularies of dress, accessories, numbers, purchase, style, appreciation etc.

Unit-2
Teaching Hours:8
Étape 6 Fashion and us
 

          Talking about fashion

 

          Talking about what we buy

 

          Describe our style

Vocabularies of dress, accessories, numbers, purchase, style, appreciation etc.

          Les adjectifs démonstratifs

          Le verbe pouvoir

          Les articles indéfinis et définis

La question avec quel(le)(s) 

  • Talking about fashion

  • Talking about what we buy

  • Describe our style

  • Vocabularies of dress, accessories, numbers, purchase, style, appreciation etc.

Unit-3
Teaching Hours:8
Étape 7 At our home
 

          Le verbe venir

          Les préposition de lieu

          L’impératif pour donner des conseils

          Chez+pronotonique

          Les verbes pronominaux

Unit-3
Teaching Hours:8
Étape 7 At our home
 

          Le verbe venir

          Les préposition de lieu

          L’impératif pour donner des conseils

          Chez+pronotonique

          Les verbes pronominaux

Unit-4
Teaching Hours:8
Étape 8
 

          Talking about dream destinations

          Making holiday plans

          Telling the story of a trip

Vocabularies of countries, islands, capitals, continents, places, cacations, climate, etc.

 

          Le verbe partir

          Le futur proche

Les prépositions devant les noms de pays, d’îles et de villes

Unit-4
Teaching Hours:8
Étape 8
 

          Talking about dream destinations

          Making holiday plans

          Telling the story of a trip

Vocabularies of countries, islands, capitals, continents, places, cacations, climate, etc.

 

          Le verbe partir

          Le futur proche

Les prépositions devant les noms de pays, d’îles et de villes

Text Books And Reference Books:

French websites like Duolingo, Bonjour de France, Fluent U French, Learn French Lab, Point du FLE etc.

Essential Reading / Recommended Reading

             French websites like Duolingo, Bonjour de France, Fluent U French, Learn French Lab, Point du FLE etc.

Evaluation Pattern

CIA -1 10 marks

CIA- 2  50 marks

CIA –3  10 marks

ESE   50 marks.

    

Question Paper Pattern

        Section A – Reading comprehension   –10 marks

        Section B – Grammar and translation - 20 marks

        Section C - Writing skills include – dialogue, email, invitation letter, essay- 20 marks

BCA181B-4 - GERMAN (2023 Batch)

Total Teaching Hours for Semester:30
No of Lecture Hours/Week:2
Max Marks:50
Credits:2

Course Objectives/Course Description

 

Course Description: This course mainly deals with the listening, speaking, writing, reading modules of basic German by using different pedagogies and effective strategies in order to meet the requirements of various situations. This course also enables the students to have cross-cultural competencies and cognitive skills.

 

Course Objectives:

 

·       To achieve language proficiency skills on the medium level

·       To develop the skills demonstrated in the ability to interpret simple texts

·       To attain some transcultural competency: an awareness of cross-cultural differences between societies.

·       To develop the ability to formulate questions

Learning Outcome

CO1: Understand and perform tasks in varied areas of social life with the help of the acquisition of communicative, linguistic and cultural know-how

CO2: Judge and do tasks in varied areas of day-to-day life activities

CO3: Formulate phrases related to personal details and particular concrete situations.

CO4: Recall the basic phrases and use them effectively

CO5: Interact and speak in small social gatherings.

Unit-1
Teaching Hours:8
Unit I
 

Alltag und Familie  : die Uhrzeit verstehen und nennen Zeitangaben machen über Familie sprechen | sich verabreden einen Termin telefonisch vereinbaren sich für eine Verspätung entschuldigen und darauf reagieren. Possessiveartikel: mein, dein,..,Zeitangaben mit am, um , von.....bis, Modalverben im Satz: Satzklammer, Modalverben müssen, können und  wollen.

Unit-1
Teaching Hours:8
Unit I
 

Alltag und Familie  : die Uhrzeit verstehen und nennen Zeitangaben machen über Familie sprechen | sich verabreden einen Termin telefonisch vereinbaren sich für eine Verspätung entschuldigen und darauf reagieren. Possessiveartikel: mein, dein,..,Zeitangaben mit am, um , von.....bis, Modalverben im Satz: Satzklammer, Modalverben müssen, können und  wollen.

Unit-2
Teaching Hours:8
Unit II
 

Zeit mit Freunden : eine Einladung verstehen und schreiben,etwas gemeinsam planen, im Restaurant bestellen und bezahlen,über ein Ereignis sprechen,über Geburtstage sprechen,bestimmte Informationen in Texten finden, Veranstaltungstipps im Radio verstehen. Präposition für + Akkusativ mich, dich ...,Datumsangaben: am ...., trennbare Verben. Präteritum von haben und sein

Unit-2
Teaching Hours:8
Unit II
 

Zeit mit Freunden : eine Einladung verstehen und schreiben,etwas gemeinsam planen, im Restaurant bestellen und bezahlen,über ein Ereignis sprechen,über Geburtstage sprechen,bestimmte Informationen in Texten finden, Veranstaltungstipps im Radio verstehen. Präposition für + Akkusativ mich, dich ...,Datumsangaben: am ...., trennbare Verben. Präteritum von haben und sein

Unit-3
Teaching Hours:7
Unit III
 

Arbeitsalltag: einen Blogbeitrag verstehen über den (Arbeits-)Alltag schreiben | Gespräche am Arbeitsplatz verstehen | Ortsangaben machen | Abläufe beschreiben | Briefe verstehen und beantworten Small Talk machen

Unit-3
Teaching Hours:7
Unit III
 

Arbeitsalltag: einen Blogbeitrag verstehen über den (Arbeits-)Alltag schreiben | Gespräche am Arbeitsplatz verstehen | Ortsangaben machen | Abläufe beschreiben | Briefe verstehen und beantworten Small Talk machen

Unit-4
Teaching Hours:7
Unit IV
 

Fit und gesund: Aufforderungen verstehen und ausdrücken | persönliche Angaben machen | Körperteile nennen Anweisungen wiedergeben | Gesundheitstipps verstehen. Gespräche beim Arzt führen | Anweisungen verstehen und geben | und geben. Korperteile Krankheiten | Medikamente |

                      Berufe im Krankenhaus. Imperativ mit du, ihr und Sie Imperativsätze | Modalverben: können, sollen, müssen, dürfen, wollen, möchten, mögen, 

                      Perfekt mit haben und sein     

Unit-4
Teaching Hours:7
Unit IV
 

Fit und gesund: Aufforderungen verstehen und ausdrücken | persönliche Angaben machen | Körperteile nennen Anweisungen wiedergeben | Gesundheitstipps verstehen. Gespräche beim Arzt führen | Anweisungen verstehen und geben | und geben. Korperteile Krankheiten | Medikamente |

                      Berufe im Krankenhaus. Imperativ mit du, ihr und Sie Imperativsätze | Modalverben: können, sollen, müssen, dürfen, wollen, möchten, mögen, 

                      Perfekt mit haben und sein     

Text Books And Reference Books:

Netzwerk neu Deutsch als Fremdsprache A1 Textbook, Workbook, Glossar and 2cds by Stefanie Dengler, Paul Rusch, Helen Schmitz, Tanja Sieber, Klett -Langenscheidt publishers

Essential Reading / Recommended Reading

 

  1. Studio d A1 set of three books and CD by Herr Mann Funk, Cornelsen publishers

  2. Deutsch Sprachlehre für Ausländer and Glossar Deutsch-English by Heinz Griesbach-Dora Schulz, Max Hueber publishers

  3. Deutsch für den Beruf text book by Adelheid h, Max Hueber publishers

  4. Deutsch für den Beruf work book by Adelheid h, Max Hueber publishers

  5. Grammatik intensiv trainer A1 Deutsch – Langenscheidt by Mark Lester, Larry Beason, Langenscheid publishers

  6. Fit für Goethe Zetifikat A1 start Deutsch 1 by Johaness Gerbes, Frau ke van der Werff, Hueber publishers

  7. Learn german through games and activities level1 Deutsch als Fremdsprache/Kursbuch und Arbeitsbuch and CD by Sabine Emmerich & Federica Colombo, eli publishers

Evaluation Pattern

1.     Federica Colombo, eli publishers

 

Evaluation Pattern

Assessment Pattern

CIA (Weight)

ESE (Weight)

CIA 1 – Assignments / Creative Projects

10%

 

CIA 2 –Mid Semester Exam

25%

 

CIA 3 – Viva / Group assignment

10%

 

Attendance

05%

 

End Semester Exam

 

50%

Total

50%

50%

BCA201-4 - GRAPH THEORY (2023 Batch)

Total Teaching Hours for Semester:45
No of Lecture Hours/Week:3
Max Marks:100
Credits:3

Course Objectives/Course Description

 

 It is a fundamental course in Graph Theory involving some basic concepts like Classes of Graphs, Isomorphism, Connectivity, spanning trees and few standard graph algorithms. his course will help the learner to

COBJ1:gain familiarity with fundamental concepts of Graph Theory

COBJ2: understand and apply knowledge to analyze and solve problems using models of Graph Theory

 

Learning Outcome

CO1: Enhance research, inquiry and analytical thinking abilities.

CO2: Improve proof writing skills.

CO3: Apply the basics of Graph Theory in solving practical problems

Unit-1
Teaching Hours:15
Introduction to Graphs
 

Graphs and Graph Models, Graph Terminology and Special Types of Graphs, Representing Graphs and Graph Isomorphism, Connectivity.

Unit-1
Teaching Hours:15
Introduction to Graphs
 

Graphs and Graph Models, Graph Terminology and Special Types of Graphs, Representing Graphs and Graph Isomorphism, Connectivity.

Unit-1
Teaching Hours:15
Introduction to Graphs
 

Graphs and Graph Models, Graph Terminology and Special Types of Graphs, Representing Graphs and Graph Isomorphism, Connectivity.

Unit-2
Teaching Hours:15
Algorithmic Graph Theory
 

Euler and Hamilton Paths, Shortest-Path Problems, Planar Graphs, Graph Coloring

Unit-2
Teaching Hours:15
Algorithmic Graph Theory
 

Euler and Hamilton Paths, Shortest-Path Problems, Planar Graphs, Graph Coloring

Unit-2
Teaching Hours:15
Algorithmic Graph Theory
 

Euler and Hamilton Paths, Shortest-Path Problems, Planar Graphs, Graph Coloring

Unit-3
Teaching Hours:15
Trees
 

 Introduction to Trees, Applications of Trees, Tree Traversal, Spanning Trees, Minimum Spanning Trees

Unit-3
Teaching Hours:15
Trees
 

 Introduction to Trees, Applications of Trees, Tree Traversal, Spanning Trees, Minimum Spanning Trees

Unit-3
Teaching Hours:15
Trees
 

 Introduction to Trees, Applications of Trees, Tree Traversal, Spanning Trees, Minimum Spanning Trees

Text Books And Reference Books:

[1]N Deo, Graph Theory with applications to engineering and computer science, Delhi: Prentice Hall of India, 1979.

[2] D.B. West, Introduction to Graph Theory, New Delhi: Prentice-Hall of India, 2011.

[3] J. P. Tremblay and R. Manohar, Discrete Mathematical Structures with Application to Computer Science, Reprint, India: Tata McGraw Hill Education, 2008.

[4] R.P. Grimaldi and B.V. Ramana, Discrete and Combinatorial Mathematics, An applied introduction, 5th ed., Pearson Education, 2007.

[5] D. S. Chandrasekharaiah, Discrete Mathematical Structures, 4th ed., India: PRISM Book Pvt. Ltd., 2012

Essential Reading / Recommended Reading

 [1] K. H. Rosen, Discrete Mathematics and its Applications, 7th ed., McGraw – Hill, 2012.

Evaluation Pattern

CIA - 50%

ESE - 50%

BCA202-4 - DATA PROCESSING WITH SPREADSHEET (2023 Batch)

Total Teaching Hours for Semester:50
No of Lecture Hours/Week:4
Max Marks:50
Credits:2

Course Objectives/Course Description

 

 

The objective of the course is to develop knowledge and skills on Data Processing so that the students are able to apply the same in understanding and analysing the data and generating insights for decisions making.

Learning Outcome

CO1: Demonstrate the ability to use and apply various functions to process and visualize the real world data.

CO2: Apply the knowledge to interprets and generates meaningful insights of data

CO3: Effectively summarize and analyze large datasets for informed decision-making.

CO4: Automate repetitive tasks, streamline complex processes and reporting capabilities

Unit-1
Teaching Hours:10
Introduction: Basic Microsoft Excel and Protecting Excel
 

 Introduction: Basic Microsoft Excel – Spread sheet basics, working with functions and basic formulas,  function wizards,  relative,  absolute and mixed cell references, basic formatting(Number formats, Font formats, Alignment, Borders, etc), Text functions(Upper, Lower, Proper, Left, Mid, Right, Trim, Len, Exact, Concatenate,Find, Substitute),  Basic conditional formatting, common functions(avg, min, max, count, counta), nested functions. Protection-File level, workbook level, work sheet level. Advanced Paste special techniques(Paste formula, paste format, etc, transpose table, Paste validations) Printing Workbooks(Settingup Print area, Customizing Headers & Footers, Designing the structure of a template, Print Titles –Repeat Rows / Columns)

Unit-1
Teaching Hours:10
Practical Problems:
 

1) Create a spread sheet , format the sheet and apply basic functions, like sum, avg, min, max count.

2) Create a spread sheet  and apply conditional formatting, sort the sheet, filter data.

3) Create a spread sheet containing textual data and apply text functions (Upper, Lower, Proper, Left, Mid, Right, Trim, Len, Exact, Concatenate, Find, Substitute)

4)Create a spreadsheet containing sales data for a company. The data includes the sales figures for each product for each month of the year. Calculate the total sales for each product for the entire year, Calculate the average sales for each product, Identify the best-selling product (the product with the highest total sales), Identify the month with the highest sales.

5) Create a spread sheet of student data base with 200 students  with 5 subject marks, generate the marks of a student with random function. Format the sheet, apply text functions, Calculate the total marks, Percentage and result as ‘Distinction, First Class, Second Class, Pass, Fail) against each student, average score of each subject, identify the subject with highest average score, Apply conditional formatting to highlight any scores below 70 in red. Apply protections at all levels. Set up print area, Print Titles –Repeat Rows / Columns, Customizing Headers & Footers

Unit-1
Teaching Hours:10
Introduction: Basic Microsoft Excel and Protecting Excel
 

 Introduction: Basic Microsoft Excel – Spread sheet basics, working with functions and basic formulas,  function wizards,  relative,  absolute and mixed cell references, basic formatting(Number formats, Font formats, Alignment, Borders, etc), Text functions(Upper, Lower, Proper, Left, Mid, Right, Trim, Len, Exact, Concatenate,Find, Substitute),  Basic conditional formatting, common functions(avg, min, max, count, counta), nested functions. Protection-File level, workbook level, work sheet level. Advanced Paste special techniques(Paste formula, paste format, etc, transpose table, Paste validations) Printing Workbooks(Settingup Print area, Customizing Headers & Footers, Designing the structure of a template, Print Titles –Repeat Rows / Columns)

Unit-1
Teaching Hours:10
Practical Problems:
 

1) Create a spread sheet , format the sheet and apply basic functions, like sum, avg, min, max count.

2) Create a spread sheet  and apply conditional formatting, sort the sheet, filter data.

3) Create a spread sheet containing textual data and apply text functions (Upper, Lower, Proper, Left, Mid, Right, Trim, Len, Exact, Concatenate, Find, Substitute)

4)Create a spreadsheet containing sales data for a company. The data includes the sales figures for each product for each month of the year. Calculate the total sales for each product for the entire year, Calculate the average sales for each product, Identify the best-selling product (the product with the highest total sales), Identify the month with the highest sales.

5) Create a spread sheet of student data base with 200 students  with 5 subject marks, generate the marks of a student with random function. Format the sheet, apply text functions, Calculate the total marks, Percentage and result as ‘Distinction, First Class, Second Class, Pass, Fail) against each student, average score of each subject, identify the subject with highest average score, Apply conditional formatting to highlight any scores below 70 in red. Apply protections at all levels. Set up print area, Print Titles –Repeat Rows / Columns, Customizing Headers & Footers

Unit-1
Teaching Hours:10
Introduction: Basic Microsoft Excel and Protecting Excel
 

 Introduction: Basic Microsoft Excel – Spread sheet basics, working with functions and basic formulas,  function wizards,  relative,  absolute and mixed cell references, basic formatting(Number formats, Font formats, Alignment, Borders, etc), Text functions(Upper, Lower, Proper, Left, Mid, Right, Trim, Len, Exact, Concatenate,Find, Substitute),  Basic conditional formatting, common functions(avg, min, max, count, counta), nested functions. Protection-File level, workbook level, work sheet level. Advanced Paste special techniques(Paste formula, paste format, etc, transpose table, Paste validations) Printing Workbooks(Settingup Print area, Customizing Headers & Footers, Designing the structure of a template, Print Titles –Repeat Rows / Columns)

Unit-1
Teaching Hours:10
Practical Problems:
 

1) Create a spread sheet , format the sheet and apply basic functions, like sum, avg, min, max count.

2) Create a spread sheet  and apply conditional formatting, sort the sheet, filter data.

3) Create a spread sheet containing textual data and apply text functions (Upper, Lower, Proper, Left, Mid, Right, Trim, Len, Exact, Concatenate, Find, Substitute)

4)Create a spreadsheet containing sales data for a company. The data includes the sales figures for each product for each month of the year. Calculate the total sales for each product for the entire year, Calculate the average sales for each product, Identify the best-selling product (the product with the highest total sales), Identify the month with the highest sales.

5) Create a spread sheet of student data base with 200 students  with 5 subject marks, generate the marks of a student with random function. Format the sheet, apply text functions, Calculate the total marks, Percentage and result as ‘Distinction, First Class, Second Class, Pass, Fail) against each student, average score of each subject, identify the subject with highest average score, Apply conditional formatting to highlight any scores below 70 in red. Apply protections at all levels. Set up print area, Print Titles –Repeat Rows / Columns, Customizing Headers & Footers

Unit-2
Teaching Hours:10
Statistics Tools
 

Mean, median, mode, standard deviation, variance, correlation, regression.

Unit-2
Teaching Hours:10
Data validation
 

 

Number, date & time validation, text and list validation, custom validations based on formula for a cell. 

Unit-2
Teaching Hours:10
Advanced Functions, Data Validation and Statistical Tools
 

Advanced functions like time, date(Today, Now, Date, Date if, DateAdd, Day, Month, Year,  Weekday), Filtering on Text, Numbers & Colors, Sorting Options, Advanced Filters on 15-20 different criteria(s), sumif, sumifs countif, countifs, averageif, averageifs, nested if, iferror statement, and, or, not, Lookup, Vlookup, H Lookup, Nested Lookup, Reverse Lookup, what-if analysis, Goal-Seek, Data Tables (PMT Function), Solver Tool, Scenario Analysis

Unit-2
Teaching Hours:10
Practical Problems
 

1) Create a spread sheet and apply data validation.

2) Create a spread sheet and use the advanced fuctions sumif, countif, averageif.

3) Create two Excel spreadsheets. The first spreadsheet contains the employee ID, name, department, and salary of each employee. The second spreadsheet contains a list of projects and the employee ID of the employee assigned to each project.  Use Excel's lookup functions to create a new spreadsheet that combines the information from both spreadsheets.



  1. Use the VLOOKUP function to add the employee name, department, and salary to the project spreadsheet based on the employee ID.

  2. Use the INDEX and MATCH functions to achieve the same result as in Requirement 1.

  3. Create a summary report that shows the total salary expenditure for each department based on the projects assigned to employees in that department.

  4. Use the SUMIF or SUMIFS function to calculate the total salary expenditure for each department.

  5. Apply conditional formatting to highlight any discrepancies or errors in the data (e.g., missing employee IDs, incorrect project assignments).

 

4) Consider an Excel spreadsheet containing the grades of students in a class for a particular subject. The data includes the student ID, name, and their scores for quizzes, midterms, and the final exam. Use the statistical tools to

  1. Calculate the mean, median, and mode of the quiz scores, midterm scores, final exam scores, and overall scores for the class.

  2. Calculate the standard deviation and variance of the quiz scores, midterm scores, final exam scores, and overall scores for the class.

  3. Determine if there is a correlation between the quiz scores, midterm scores, and final exam scores.

  4. Use regression analysis to predict the final exam score based on the quiz scores and midterm scores.

  5. Create a summary report that presents the results of the statistical analyses and provides insights into the performance of the class.

 

5)Consider an Excel spreadsheet containing sales data for a company over the past year. The data includes   Product ID, Product Name, Product Category, Region, Sales figures for each month (January to December)

  1. Implement number validation for the sales figures to ensure that only numerical values are entered.

  2. Implement text validation for the product names to ensure that only text values are entered.

  3. Create a dropdown list for the product categories to ensure that only predefined categories can be selected.

  4. Implement a custom validation rule to ensure that the total sales for each product match the sum of sales for each month.

  5. Restrict the input range for the product IDs to a specific range of values.

  6. Implement a rule to prevent duplicate product IDs from being entered.

  7. Ensure that each product ID is unique within the dataset.

  8. Implement a rule to ensure that all cells in the sales data table are filled before saving the spreadsheet.

  9. Calculate the total sales for each product for the entire year.

  10. Calculate the average sales for each product.

  11. Identify the best-selling product (the product with the highest total sales).

  12. Calculate the total sales for each region for the entire year.

  13. Calculate the average sales for each region.

  14. Identify the region with the highest total sales.

  15. Use the Analysis ToolPak add-in to perform a regression analysis to determine if there is a relationship between sales and the month or region.

  16. Create a summary report that presents the results of the statistical analyses in a clear and concise manner.

  17. Using the VLOOKUP function, retrieve the product name for a given product ID 

  18. Using the HLOOKUP function, retrieve the total sales for the month product ID 

  19. Use the INDEX and MATCH functions to find the region with the highest total sales.

  20. Nest the VLOOKUP function inside an IF function to display "Best Seller" for the product with the highest total sales and "Not Best Seller" for others.

  21. Reverse Lookup: Using the INDEX and MATCH functions, find the product ID for the product with the highest total sales.

Nested Lookup: Nest the VLOOKUP function inside another VLOOKUP function to retrieve the region for the product with the highest total sales.

Unit-2
Teaching Hours:10
Statistics Tools
 

Mean, median, mode, standard deviation, variance, correlation, regression.

Unit-2
Teaching Hours:10
Data validation
 

 

Number, date & time validation, text and list validation, custom validations based on formula for a cell. 

Unit-2
Teaching Hours:10
Advanced Functions, Data Validation and Statistical Tools
 

Advanced functions like time, date(Today, Now, Date, Date if, DateAdd, Day, Month, Year,  Weekday), Filtering on Text, Numbers & Colors, Sorting Options, Advanced Filters on 15-20 different criteria(s), sumif, sumifs countif, countifs, averageif, averageifs, nested if, iferror statement, and, or, not, Lookup, Vlookup, H Lookup, Nested Lookup, Reverse Lookup, what-if analysis, Goal-Seek, Data Tables (PMT Function), Solver Tool, Scenario Analysis

Unit-2
Teaching Hours:10
Practical Problems
 

1) Create a spread sheet and apply data validation.

2) Create a spread sheet and use the advanced fuctions sumif, countif, averageif.

3) Create two Excel spreadsheets. The first spreadsheet contains the employee ID, name, department, and salary of each employee. The second spreadsheet contains a list of projects and the employee ID of the employee assigned to each project.  Use Excel's lookup functions to create a new spreadsheet that combines the information from both spreadsheets.



  1. Use the VLOOKUP function to add the employee name, department, and salary to the project spreadsheet based on the employee ID.

  2. Use the INDEX and MATCH functions to achieve the same result as in Requirement 1.

  3. Create a summary report that shows the total salary expenditure for each department based on the projects assigned to employees in that department.

  4. Use the SUMIF or SUMIFS function to calculate the total salary expenditure for each department.

  5. Apply conditional formatting to highlight any discrepancies or errors in the data (e.g., missing employee IDs, incorrect project assignments).

 

4) Consider an Excel spreadsheet containing the grades of students in a class for a particular subject. The data includes the student ID, name, and their scores for quizzes, midterms, and the final exam. Use the statistical tools to

  1. Calculate the mean, median, and mode of the quiz scores, midterm scores, final exam scores, and overall scores for the class.

  2. Calculate the standard deviation and variance of the quiz scores, midterm scores, final exam scores, and overall scores for the class.

  3. Determine if there is a correlation between the quiz scores, midterm scores, and final exam scores.

  4. Use regression analysis to predict the final exam score based on the quiz scores and midterm scores.

  5. Create a summary report that presents the results of the statistical analyses and provides insights into the performance of the class.

 

5)Consider an Excel spreadsheet containing sales data for a company over the past year. The data includes   Product ID, Product Name, Product Category, Region, Sales figures for each month (January to December)

  1. Implement number validation for the sales figures to ensure that only numerical values are entered.

  2. Implement text validation for the product names to ensure that only text values are entered.

  3. Create a dropdown list for the product categories to ensure that only predefined categories can be selected.

  4. Implement a custom validation rule to ensure that the total sales for each product match the sum of sales for each month.

  5. Restrict the input range for the product IDs to a specific range of values.

  6. Implement a rule to prevent duplicate product IDs from being entered.

  7. Ensure that each product ID is unique within the dataset.

  8. Implement a rule to ensure that all cells in the sales data table are filled before saving the spreadsheet.

  9. Calculate the total sales for each product for the entire year.

  10. Calculate the average sales for each product.

  11. Identify the best-selling product (the product with the highest total sales).

  12. Calculate the total sales for each region for the entire year.

  13. Calculate the average sales for each region.

  14. Identify the region with the highest total sales.

  15. Use the Analysis ToolPak add-in to perform a regression analysis to determine if there is a relationship between sales and the month or region.

  16. Create a summary report that presents the results of the statistical analyses in a clear and concise manner.

  17. Using the VLOOKUP function, retrieve the product name for a given product ID 

  18. Using the HLOOKUP function, retrieve the total sales for the month product ID 

  19. Use the INDEX and MATCH functions to find the region with the highest total sales.

  20. Nest the VLOOKUP function inside an IF function to display "Best Seller" for the product with the highest total sales and "Not Best Seller" for others.

  21. Reverse Lookup: Using the INDEX and MATCH functions, find the product ID for the product with the highest total sales.

Nested Lookup: Nest the VLOOKUP function inside another VLOOKUP function to retrieve the region for the product with the highest total sales.

Unit-2
Teaching Hours:10
Statistics Tools
 

Mean, median, mode, standard deviation, variance, correlation, regression.

Unit-2
Teaching Hours:10
Data validation
 

 

Number, date & time validation, text and list validation, custom validations based on formula for a cell. 

Unit-2
Teaching Hours:10
Advanced Functions, Data Validation and Statistical Tools
 

Advanced functions like time, date(Today, Now, Date, Date if, DateAdd, Day, Month, Year,  Weekday), Filtering on Text, Numbers & Colors, Sorting Options, Advanced Filters on 15-20 different criteria(s), sumif, sumifs countif, countifs, averageif, averageifs, nested if, iferror statement, and, or, not, Lookup, Vlookup, H Lookup, Nested Lookup, Reverse Lookup, what-if analysis, Goal-Seek, Data Tables (PMT Function), Solver Tool, Scenario Analysis

Unit-2
Teaching Hours:10
Practical Problems
 

1) Create a spread sheet and apply data validation.

2) Create a spread sheet and use the advanced fuctions sumif, countif, averageif.

3) Create two Excel spreadsheets. The first spreadsheet contains the employee ID, name, department, and salary of each employee. The second spreadsheet contains a list of projects and the employee ID of the employee assigned to each project.  Use Excel's lookup functions to create a new spreadsheet that combines the information from both spreadsheets.



  1. Use the VLOOKUP function to add the employee name, department, and salary to the project spreadsheet based on the employee ID.

  2. Use the INDEX and MATCH functions to achieve the same result as in Requirement 1.

  3. Create a summary report that shows the total salary expenditure for each department based on the projects assigned to employees in that department.

  4. Use the SUMIF or SUMIFS function to calculate the total salary expenditure for each department.

  5. Apply conditional formatting to highlight any discrepancies or errors in the data (e.g., missing employee IDs, incorrect project assignments).

 

4) Consider an Excel spreadsheet containing the grades of students in a class for a particular subject. The data includes the student ID, name, and their scores for quizzes, midterms, and the final exam. Use the statistical tools to

  1. Calculate the mean, median, and mode of the quiz scores, midterm scores, final exam scores, and overall scores for the class.

  2. Calculate the standard deviation and variance of the quiz scores, midterm scores, final exam scores, and overall scores for the class.

  3. Determine if there is a correlation between the quiz scores, midterm scores, and final exam scores.

  4. Use regression analysis to predict the final exam score based on the quiz scores and midterm scores.

  5. Create a summary report that presents the results of the statistical analyses and provides insights into the performance of the class.

 

5)Consider an Excel spreadsheet containing sales data for a company over the past year. The data includes   Product ID, Product Name, Product Category, Region, Sales figures for each month (January to December)

  1. Implement number validation for the sales figures to ensure that only numerical values are entered.

  2. Implement text validation for the product names to ensure that only text values are entered.

  3. Create a dropdown list for the product categories to ensure that only predefined categories can be selected.

  4. Implement a custom validation rule to ensure that the total sales for each product match the sum of sales for each month.

  5. Restrict the input range for the product IDs to a specific range of values.

  6. Implement a rule to prevent duplicate product IDs from being entered.

  7. Ensure that each product ID is unique within the dataset.

  8. Implement a rule to ensure that all cells in the sales data table are filled before saving the spreadsheet.

  9. Calculate the total sales for each product for the entire year.

  10. Calculate the average sales for each product.

  11. Identify the best-selling product (the product with the highest total sales).

  12. Calculate the total sales for each region for the entire year.

  13. Calculate the average sales for each region.

  14. Identify the region with the highest total sales.

  15. Use the Analysis ToolPak add-in to perform a regression analysis to determine if there is a relationship between sales and the month or region.

  16. Create a summary report that presents the results of the statistical analyses in a clear and concise manner.

  17. Using the VLOOKUP function, retrieve the product name for a given product ID 

  18. Using the HLOOKUP function, retrieve the total sales for the month product ID 

  19. Use the INDEX and MATCH functions to find the region with the highest total sales.

  20. Nest the VLOOKUP function inside an IF function to display "Best Seller" for the product with the highest total sales and "Not Best Seller" for others.

  21. Reverse Lookup: Using the INDEX and MATCH functions, find the product ID for the product with the highest total sales.

Nested Lookup: Nest the VLOOKUP function inside another VLOOKUP function to retrieve the region for the product with the highest total sales.

Unit-3
Teaching Hours:10
Data Visuliazation and Macros
 

 Charts and Graphs: Different types of charts and graph, Creating a chart, Parts of chart, Changing chart type, changing chart options. (Line, bar, pie, scatter, area, doughnut, surface, 3d bar, 3d column, 3d line, 3d pie, 3d surface )

Unit-3
Teaching Hours:10
Practical Problems
 
  1. Use the spreadsheet data and represent them in various types of charts and interpret the result.

  2. Consider an Excel spreadsheet containing data from a customer satisfaction survey conducted by a company. The data includes Customer ID, Date of Survey, Overall Satisfaction (Scale of 1 to 5), Satisfaction with Product Quality (Scale of 1 to 5), Satisfaction with Customer Service (Scale of 1 to 5), Likelihood to Recommend (Scale of 1 to 5.

  1. Create a histogram to visualize the distribution of overall satisfaction scores.

  2. Create a line chart to track the trend in satisfaction with product quality over time.

  3. Create a 2D and 3D bar chart to compare satisfaction with customer service across different customer segments (e.g., age groups, regions).

  4. Create a chart to show the distribution of likelihood to recommend scores.

  5. Create a scatter plot to analyze the relationship between overall satisfaction and likelihood to recommend.

  1. Write a macro to automatically format a selected range of cells with borders and shading.

  1. Write a macro to sort a list of names in alphabetical order.

  1. Write a macro to filter a list of numbers to show only those that are greater than a specified value.

  1. Write a macro to calculate the total sales for each product category and display the results in a new worksheet.

 

  1. Write a macro to create a new workbook and copy data from an existing workbook to the new workbook.

Unit-3
Teaching Hours:10
Introduction to macros
 

 

Definition and use, record a macro, store a macro, assign a macro, run a macros. 

Unit-3
Teaching Hours:10
Data Visuliazation and Macros
 

 Charts and Graphs: Different types of charts and graph, Creating a chart, Parts of chart, Changing chart type, changing chart options. (Line, bar, pie, scatter, area, doughnut, surface, 3d bar, 3d column, 3d line, 3d pie, 3d surface )

Unit-3
Teaching Hours:10
Practical Problems
 
  1. Use the spreadsheet data and represent them in various types of charts and interpret the result.

  2. Consider an Excel spreadsheet containing data from a customer satisfaction survey conducted by a company. The data includes Customer ID, Date of Survey, Overall Satisfaction (Scale of 1 to 5), Satisfaction with Product Quality (Scale of 1 to 5), Satisfaction with Customer Service (Scale of 1 to 5), Likelihood to Recommend (Scale of 1 to 5.

  1. Create a histogram to visualize the distribution of overall satisfaction scores.

  2. Create a line chart to track the trend in satisfaction with product quality over time.

  3. Create a 2D and 3D bar chart to compare satisfaction with customer service across different customer segments (e.g., age groups, regions).

  4. Create a chart to show the distribution of likelihood to recommend scores.

  5. Create a scatter plot to analyze the relationship between overall satisfaction and likelihood to recommend.

  1. Write a macro to automatically format a selected range of cells with borders and shading.

  1. Write a macro to sort a list of names in alphabetical order.

  1. Write a macro to filter a list of numbers to show only those that are greater than a specified value.

  1. Write a macro to calculate the total sales for each product category and display the results in a new worksheet.

 

  1. Write a macro to create a new workbook and copy data from an existing workbook to the new workbook.

Unit-3
Teaching Hours:10
Introduction to macros
 

 

Definition and use, record a macro, store a macro, assign a macro, run a macros. 

Unit-3
Teaching Hours:10
Data Visuliazation and Macros
 

 Charts and Graphs: Different types of charts and graph, Creating a chart, Parts of chart, Changing chart type, changing chart options. (Line, bar, pie, scatter, area, doughnut, surface, 3d bar, 3d column, 3d line, 3d pie, 3d surface )

Unit-3
Teaching Hours:10
Practical Problems
 
  1. Use the spreadsheet data and represent them in various types of charts and interpret the result.

  2. Consider an Excel spreadsheet containing data from a customer satisfaction survey conducted by a company. The data includes Customer ID, Date of Survey, Overall Satisfaction (Scale of 1 to 5), Satisfaction with Product Quality (Scale of 1 to 5), Satisfaction with Customer Service (Scale of 1 to 5), Likelihood to Recommend (Scale of 1 to 5.

  1. Create a histogram to visualize the distribution of overall satisfaction scores.

  2. Create a line chart to track the trend in satisfaction with product quality over time.

  3. Create a 2D and 3D bar chart to compare satisfaction with customer service across different customer segments (e.g., age groups, regions).

  4. Create a chart to show the distribution of likelihood to recommend scores.

  5. Create a scatter plot to analyze the relationship between overall satisfaction and likelihood to recommend.

  1. Write a macro to automatically format a selected range of cells with borders and shading.

  1. Write a macro to sort a list of names in alphabetical order.

  1. Write a macro to filter a list of numbers to show only those that are greater than a specified value.

  1. Write a macro to calculate the total sales for each product category and display the results in a new worksheet.

 

  1. Write a macro to create a new workbook and copy data from an existing workbook to the new workbook.

Unit-3
Teaching Hours:10
Introduction to macros
 

 

Definition and use, record a macro, store a macro, assign a macro, run a macros. 

Unit-4
Teaching Hours:10
Arrays, Pivot Table and Excel Dash Board
 

 

Arrays definition of array formulas, uses, array with if, len, and mid functions formulas, basic examples of arrays (Using ctrl+shift+enter), advanced Use of formulas with array, array with Lookup functions.

Unit-4
Teaching Hours:10
Pivot Table
 

Introduction, uses, Create a Pivot Table, Add data to the Pivot table, Filter the Pivot Table Data, Analyze the Data Columns in Pivot Table, Filtering PivotTables, Modifying PivotTable Data, Grouping based on numbers and Dates

 

Unit-4
Teaching Hours:10
Practical Problems
 

1)  Create a Pivot Table and apply filter in it

2)  Create a Pivot table and apply grouping functions

3)  Consider a list of numbers in cells A1:A10. Use array formulas to calculate the sum of the squares of all numbers in the list, the average of the numbers in the list that are greater than 50, the product of the numbers in the list that are less than 10, The median of the numbers in the list, the mode of the numbers in the list.

4)  Consider an Excel spreadsheet containing student names and their test scores for three subjects: Math, English, and Science. Use array formulas to perform various calculations and manipulations on the data. Find total score for each student, total score for each subject, average score for each student, average score for each subject, highest score for each student, highest score among all students for each subject, count the number of scores greater than or equal to 70 for each student, count the number of scores greater than or equal to 70 for each subject, apply conditional formatting to highlight scores below 60 in red.

5) Consider an Excel spreadsheet containing performance data for employees over the past year. The data includes Employee ID, Employee Name, Department, Region the performance ratings for each employee for each quarter (Q1 to Q4.  Use arrays and pivot tables to perform a comprehensive analysis of the employee performance data.

 

  1. Use an array formula to calculate the average performance rating for each employee for the entire year, total performance rating for each department for the entire year, average performance rating for each department.

  2. Create a pivot table to summarize the average performance rating for each employee, summarize the total performance rating for each department, compare the performance ratings of different departments across quarters, analyze the performance rating trends over the past year.

Unit-4
Teaching Hours:10
Arrays, Pivot Table and Excel Dash Board
 

 

Arrays definition of array formulas, uses, array with if, len, and mid functions formulas, basic examples of arrays (Using ctrl+shift+enter), advanced Use of formulas with array, array with Lookup functions.

Unit-4
Teaching Hours:10
Pivot Table
 

Introduction, uses, Create a Pivot Table, Add data to the Pivot table, Filter the Pivot Table Data, Analyze the Data Columns in Pivot Table, Filtering PivotTables, Modifying PivotTable Data, Grouping based on numbers and Dates

 

Unit-4
Teaching Hours:10
Practical Problems
 

1)  Create a Pivot Table and apply filter in it

2)  Create a Pivot table and apply grouping functions

3)  Consider a list of numbers in cells A1:A10. Use array formulas to calculate the sum of the squares of all numbers in the list, the average of the numbers in the list that are greater than 50, the product of the numbers in the list that are less than 10, The median of the numbers in the list, the mode of the numbers in the list.

4)  Consider an Excel spreadsheet containing student names and their test scores for three subjects: Math, English, and Science. Use array formulas to perform various calculations and manipulations on the data. Find total score for each student, total score for each subject, average score for each student, average score for each subject, highest score for each student, highest score among all students for each subject, count the number of scores greater than or equal to 70 for each student, count the number of scores greater than or equal to 70 for each subject, apply conditional formatting to highlight scores below 60 in red.

5) Consider an Excel spreadsheet containing performance data for employees over the past year. The data includes Employee ID, Employee Name, Department, Region the performance ratings for each employee for each quarter (Q1 to Q4.  Use arrays and pivot tables to perform a comprehensive analysis of the employee performance data.

 

  1. Use an array formula to calculate the average performance rating for each employee for the entire year, total performance rating for each department for the entire year, average performance rating for each department.

  2. Create a pivot table to summarize the average performance rating for each employee, summarize the total performance rating for each department, compare the performance ratings of different departments across quarters, analyze the performance rating trends over the past year.

Unit-4
Teaching Hours:10
Arrays, Pivot Table and Excel Dash Board
 

 

Arrays definition of array formulas, uses, array with if, len, and mid functions formulas, basic examples of arrays (Using ctrl+shift+enter), advanced Use of formulas with array, array with Lookup functions.

Unit-4
Teaching Hours:10
Pivot Table
 

Introduction, uses, Create a Pivot Table, Add data to the Pivot table, Filter the Pivot Table Data, Analyze the Data Columns in Pivot Table, Filtering PivotTables, Modifying PivotTable Data, Grouping based on numbers and Dates

 

Unit-4
Teaching Hours:10
Practical Problems
 

1)  Create a Pivot Table and apply filter in it

2)  Create a Pivot table and apply grouping functions

3)  Consider a list of numbers in cells A1:A10. Use array formulas to calculate the sum of the squares of all numbers in the list, the average of the numbers in the list that are greater than 50, the product of the numbers in the list that are less than 10, The median of the numbers in the list, the mode of the numbers in the list.

4)  Consider an Excel spreadsheet containing student names and their test scores for three subjects: Math, English, and Science. Use array formulas to perform various calculations and manipulations on the data. Find total score for each student, total score for each subject, average score for each student, average score for each subject, highest score for each student, highest score among all students for each subject, count the number of scores greater than or equal to 70 for each student, count the number of scores greater than or equal to 70 for each subject, apply conditional formatting to highlight scores below 60 in red.

5) Consider an Excel spreadsheet containing performance data for employees over the past year. The data includes Employee ID, Employee Name, Department, Region the performance ratings for each employee for each quarter (Q1 to Q4.  Use arrays and pivot tables to perform a comprehensive analysis of the employee performance data.

 

  1. Use an array formula to calculate the average performance rating for each employee for the entire year, total performance rating for each department for the entire year, average performance rating for each department.

  2. Create a pivot table to summarize the average performance rating for each employee, summarize the total performance rating for each department, compare the performance ratings of different departments across quarters, analyze the performance rating trends over the past year.

Unit-5
Teaching Hours:10
VBA and Excel Dash Board
 

 VBA Macro, Introduction to VBA, Variables in VBA, Message Box and Input box Functions, If and select statements, Looping in VBA

Unit-5
Teaching Hours:10
Excel Dash Board
 

 Introduction to Excel Dashboard, Planning a Dashboard, Adding Dynamic Contents to Dashboard, Adding Tables and Charts to Dashboard.

Unit-5
Teaching Hours:10
Practical Problems
 

 

  1. Declare a variable in VBA to store a number and assign it a value of 10.

  2. Declare a variable in VBA to store a string and assign it a value of "Hello, World!".

  3. Write a VBA macro that displays a message box with the text "Welcome to Excel VBA!".

  4. Write a VBA macro that uses an input box to prompt the user for their name and then displays a message box with a greeting using their name.

  5. Write a VBA macro that checks if a cell value is greater than 10 and displays a message box with "Value is greater than 10" if true.

  6. Write a VBA macro that uses a select statement to display a message box based on the value of a cell (e.g., "Value is A" if cell value is A, "Value is B" if cell value is B, etc.).

  7. Write a VBA macro that uses a for loop to display numbers from 1 to 10 in a message box.

  8. Write a VBA macro that uses a do while loop to prompt the user for a number until they enter a number greater than 100

Unit-5
Teaching Hours:10
VBA and Excel Dash Board
 

 VBA Macro, Introduction to VBA, Variables in VBA, Message Box and Input box Functions, If and select statements, Looping in VBA

Unit-5
Teaching Hours:10
Excel Dash Board
 

 Introduction to Excel Dashboard, Planning a Dashboard, Adding Dynamic Contents to Dashboard, Adding Tables and Charts to Dashboard.

Unit-5
Teaching Hours:10
Practical Problems
 

 

  1. Declare a variable in VBA to store a number and assign it a value of 10.

  2. Declare a variable in VBA to store a string and assign it a value of "Hello, World!".

  3. Write a VBA macro that displays a message box with the text "Welcome to Excel VBA!".

  4. Write a VBA macro that uses an input box to prompt the user for their name and then displays a message box with a greeting using their name.

  5. Write a VBA macro that checks if a cell value is greater than 10 and displays a message box with "Value is greater than 10" if true.

  6. Write a VBA macro that uses a select statement to display a message box based on the value of a cell (e.g., "Value is A" if cell value is A, "Value is B" if cell value is B, etc.).

  7. Write a VBA macro that uses a for loop to display numbers from 1 to 10 in a message box.

  8. Write a VBA macro that uses a do while loop to prompt the user for a number until they enter a number greater than 100

Unit-5
Teaching Hours:10
VBA and Excel Dash Board
 

 VBA Macro, Introduction to VBA, Variables in VBA, Message Box and Input box Functions, If and select statements, Looping in VBA

Unit-5
Teaching Hours:10
Excel Dash Board
 

 Introduction to Excel Dashboard, Planning a Dashboard, Adding Dynamic Contents to Dashboard, Adding Tables and Charts to Dashboard.

Unit-5
Teaching Hours:10
Practical Problems
 

 

  1. Declare a variable in VBA to store a number and assign it a value of 10.

  2. Declare a variable in VBA to store a string and assign it a value of "Hello, World!".

  3. Write a VBA macro that displays a message box with the text "Welcome to Excel VBA!".

  4. Write a VBA macro that uses an input box to prompt the user for their name and then displays a message box with a greeting using their name.

  5. Write a VBA macro that checks if a cell value is greater than 10 and displays a message box with "Value is greater than 10" if true.

  6. Write a VBA macro that uses a select statement to display a message box based on the value of a cell (e.g., "Value is A" if cell value is A, "Value is B" if cell value is B, etc.).

  7. Write a VBA macro that uses a for loop to display numbers from 1 to 10 in a message box.

  8. Write a VBA macro that uses a do while loop to prompt the user for a number until they enter a number greater than 100

Text Books And Reference Books:

[1] Microsoft Excel  Step by Step (Office 2021 and Microsoft 365),  Joan Lambert and Curtis Frye,   Microsoft Press,  2021

[2] Excel 2021: Everything You Need to Know about Excel to Go from Beginner to Expert, Nora E, Nora E Wright 2021

Essential Reading / Recommended Reading

[1] Microsoft Excel Formulas and Functions, Paul McFedries, Microsoft Press. 2022 

[2] Excel 2022 All-in-One For Dummies, Greg Harvey, For Dummies, 2021.

Evaluation Pattern

CIA -50%

ESE - 50%

BCA301-4 - DOT NET (2023 Batch)

Total Teaching Hours for Semester:75
No of Lecture Hours/Week:5
Max Marks:100
Credits:4

Course Objectives/Course Description

 

 

The course introduces the concepts of converting the real-time problems into an interactive window-based application to attain a solution.

Learning Outcome

CO1: Demonstrate an understanding of designing an interactive Graphical User Interface using Windows-based applications.

CO2: Design an application using fundamentals of object-oriented programming concepts.

CO3: Build an application using different controls available in windows form application and convert to exe file.

Unit-1
Teaching Hours:15
INTRODUCING WINDOWS FORMS
 

 

Overview of the System. Windows.Forms The Anatomy of a Form-A Simple form Program- Function with Control Class (Functionality of Control Class) -The Functionality of the form Class. Common Control I and their Runtime Properties. Data Types, Identifiers, Variables, Constants and Literals  Array and Strings  Object and Classes.

Unit-1
Teaching Hours:15
Lab Exercises
 

1.Introduction to Windows form application design (Toolbox, Property window, Solution Explorer, Server Explorer) Properties associated with each control.

2.Introduction to common controls Part I and their properties

(Text boxes, Rich Text Box, Label, Link label, Button, Panel)

 

Event associated with each of the controls. Changing the properties at runtime with C# code.

Unit-1
Teaching Hours:15
INTRODUCING WINDOWS FORMS
 

 

Overview of the System. Windows.Forms The Anatomy of a Form-A Simple form Program- Function with Control Class (Functionality of Control Class) -The Functionality of the form Class. Common Control I and their Runtime Properties. Data Types, Identifiers, Variables, Constants and Literals  Array and Strings  Object and Classes.

Unit-1
Teaching Hours:15
Lab Exercises
 

1.Introduction to Windows form application design (Toolbox, Property window, Solution Explorer, Server Explorer) Properties associated with each control.

2.Introduction to common controls Part I and their properties

(Text boxes, Rich Text Box, Label, Link label, Button, Panel)

 

Event associated with each of the controls. Changing the properties at runtime with C# code.

Unit-1
Teaching Hours:15
INTRODUCING WINDOWS FORMS
 

 

Overview of the System. Windows.Forms The Anatomy of a Form-A Simple form Program- Function with Control Class (Functionality of Control Class) -The Functionality of the form Class. Common Control I and their Runtime Properties. Data Types, Identifiers, Variables, Constants and Literals  Array and Strings  Object and Classes.

Unit-1
Teaching Hours:15
Lab Exercises
 

1.Introduction to Windows form application design (Toolbox, Property window, Solution Explorer, Server Explorer) Properties associated with each control.

2.Introduction to common controls Part I and their properties

(Text boxes, Rich Text Box, Label, Link label, Button, Panel)

 

Event associated with each of the controls. Changing the properties at runtime with C# code.

Unit-2
Teaching Hours:15
ANATOMY OF A BASIC C#
 

 

Anatomy of  C# -Default Assignment and Variable Scope, C# Member Variable Initialization Syntax-Basic Input and Output with the Console class- Array Manipulation in C# -Looping Structures in C# -If, Switch, While, Do While, For- Regular Expression fundamentals- Validating Numbers and Texts in forms.

Unit-2
Teaching Hours:15
Lab Exercises
 

3.Validating controls - Numbers, Texts

Using Regular expression

4.Looping structures

 

(If , Switch Case, While loop, Do .. While loop, For loop in C#)

Unit-2
Teaching Hours:15
ANATOMY OF A BASIC C#
 

 

Anatomy of  C# -Default Assignment and Variable Scope, C# Member Variable Initialization Syntax-Basic Input and Output with the Console class- Array Manipulation in C# -Looping Structures in C# -If, Switch, While, Do While, For- Regular Expression fundamentals- Validating Numbers and Texts in forms.

Unit-2
Teaching Hours:15
Lab Exercises
 

3.Validating controls - Numbers, Texts

Using Regular expression

4.Looping structures

 

(If , Switch Case, While loop, Do .. While loop, For loop in C#)

Unit-2
Teaching Hours:15
ANATOMY OF A BASIC C#
 

 

Anatomy of  C# -Default Assignment and Variable Scope, C# Member Variable Initialization Syntax-Basic Input and Output with the Console class- Array Manipulation in C# -Looping Structures in C# -If, Switch, While, Do While, For- Regular Expression fundamentals- Validating Numbers and Texts in forms.

Unit-2
Teaching Hours:15
Lab Exercises
 

3.Validating controls - Numbers, Texts

Using Regular expression

4.Looping structures

 

(If , Switch Case, While loop, Do .. While loop, For loop in C#)

Unit-3
Teaching Hours:15
Lab Exercises
 

5.Introduction to common controls Part II and their properties

(List Box, Combo box, Check box, Radio button, Group Box)

Events associated with each of the control, Implementation of Exception in C# code. 

6.Introduction to common controls Part III and their properties

(Date time picker, Month Calendar, Numeric up Down)

 

Implementation of Exception in C# code. Implementation of Exception in C# code.

Unit-3
Teaching Hours:15
EXCEPTIONS
 

 

Fetching Values from Windows Form and Validating using Regular Expression. Throwing a Generic Exception, Catching Exceptions, Handling Multiple Exceptions, Finally Block, Common Control II & III and their Runtime Properties. Defining Interfaces.

Unit-3
Teaching Hours:15
Lab Exercises
 

5.Introduction to common controls Part II and their properties

(List Box, Combo box, Check box, Radio button, Group Box)

Events associated with each of the control, Implementation of Exception in C# code. 

6.Introduction to common controls Part III and their properties

(Date time picker, Month Calendar, Numeric up Down)

 

Implementation of Exception in C# code. Implementation of Exception in C# code.

Unit-3
Teaching Hours:15
EXCEPTIONS
 

 

Fetching Values from Windows Form and Validating using Regular Expression. Throwing a Generic Exception, Catching Exceptions, Handling Multiple Exceptions, Finally Block, Common Control II & III and their Runtime Properties. Defining Interfaces.

Unit-3
Teaching Hours:15
Lab Exercises
 

5.Introduction to common controls Part II and their properties

(List Box, Combo box, Check box, Radio button, Group Box)

Events associated with each of the control, Implementation of Exception in C# code. 

6.Introduction to common controls Part III and their properties

(Date time picker, Month Calendar, Numeric up Down)

 

Implementation of Exception in C# code. Implementation of Exception in C# code.

Unit-3
Teaching Hours:15
EXCEPTIONS
 

 

Fetching Values from Windows Form and Validating using Regular Expression. Throwing a Generic Exception, Catching Exceptions, Handling Multiple Exceptions, Finally Block, Common Control II & III and their Runtime Properties. Defining Interfaces.

Unit-4
Teaching Hours:15
MENU CREATION AND DIALOG CONTROLS
 

Window form- usage of Common Control IV and their Runtime Properties. Menus and Toolbar controls and their runtime properties and events. Dialog Controls and their Properties.

Unit-4
Teaching Hours:15
Lab Exercises
 

7.Introduction to common controls Part IV, Menus and Tool Bars and their properties  (Progress bar, Tool Tip, Picture box) Properties associated with each of the controls

 

8.Introduction to Dialog control and its properties (Font Dialog, Open File Dialog, Save File Dialog). Changing properties at runtime using C# code.

Unit-4
Teaching Hours:15
MENU CREATION AND DIALOG CONTROLS
 

Window form- usage of Common Control IV and their Runtime Properties. Menus and Toolbar controls and their runtime properties and events. Dialog Controls and their Properties.

Unit-4
Teaching Hours:15
Lab Exercises
 

7.Introduction to common controls Part IV, Menus and Tool Bars and their properties  (Progress bar, Tool Tip, Picture box) Properties associated with each of the controls

 

8.Introduction to Dialog control and its properties (Font Dialog, Open File Dialog, Save File Dialog). Changing properties at runtime using C# code.

Unit-4
Teaching Hours:15
MENU CREATION AND DIALOG CONTROLS
 

Window form- usage of Common Control IV and their Runtime Properties. Menus and Toolbar controls and their runtime properties and events. Dialog Controls and their Properties.

Unit-4
Teaching Hours:15
Lab Exercises
 

7.Introduction to common controls Part IV, Menus and Tool Bars and their properties  (Progress bar, Tool Tip, Picture box) Properties associated with each of the controls

 

8.Introduction to Dialog control and its properties (Font Dialog, Open File Dialog, Save File Dialog). Changing properties at runtime using C# code.

Unit-5
Teaching Hours:15
Lab Exercises
 

9.Windows Form Interaction with database using SELECT, DELETE Query

Writing INSERT, UPDATE query in Windows form to store data in the database

10.Report generation using tools available and Converting the application to an exe file.

Unit-5
Teaching Hours:15
DATABASE CONNECTIVITY & EXECUTABLE FILE CREATION
 

 

Database Rudimentary Components in .NET, SQL Server Database Connectivity, SQL Query Writing Queries in SQL Server (SELECT, UPDATE, DELETE, INSERT) and retrieving data in form Controls. Windows Form Interaction with database using INSERT, UPDATE Query. Report Generation using Packages, Converting application to a .exe file.

Unit-5
Teaching Hours:15
Lab Exercises
 

9.Windows Form Interaction with database using SELECT, DELETE Query

Writing INSERT, UPDATE query in Windows form to store data in the database

10.Report generation using tools available and Converting the application to an exe file.

Unit-5
Teaching Hours:15
DATABASE CONNECTIVITY & EXECUTABLE FILE CREATION
 

 

Database Rudimentary Components in .NET, SQL Server Database Connectivity, SQL Query Writing Queries in SQL Server (SELECT, UPDATE, DELETE, INSERT) and retrieving data in form Controls. Windows Form Interaction with database using INSERT, UPDATE Query. Report Generation using Packages, Converting application to a .exe file.

Unit-5
Teaching Hours:15
Lab Exercises
 

9.Windows Form Interaction with database using SELECT, DELETE Query

Writing INSERT, UPDATE query in Windows form to store data in the database

10.Report generation using tools available and Converting the application to an exe file.

Unit-5
Teaching Hours:15
DATABASE CONNECTIVITY & EXECUTABLE FILE CREATION
 

 

Database Rudimentary Components in .NET, SQL Server Database Connectivity, SQL Query Writing Queries in SQL Server (SELECT, UPDATE, DELETE, INSERT) and retrieving data in form Controls. Windows Form Interaction with database using INSERT, UPDATE Query. Report Generation using Packages, Converting application to a .exe file.

Text Books And Reference Books:

NIL

Essential Reading / Recommended Reading

 

  1. Prashanth Kumar R, DOT NET PROGRAMMING USING C#, Blue Rose Publishers, 2023

Evaluation Pattern

CIA - 50%

ESE - 50%

BCA302-4 - PRINCIPLES OF SOFTWARE DEVELOPMENT - II (2023 Batch)

Total Teaching Hours for Semester:90
No of Lecture Hours/Week:6
Max Marks:150
Credits:5

Course Objectives/Course Description

 

 The aim is to equip students with the skills necessary to design, develop, and maintain robust software applications with efficient and scalable database backends.

Learning Outcome

CO1: Design and Develop ethical software product.

CO2: Apply terms, concepts, and tools of relational database management systems and PL/SQL concepts.

CO3: Construct database projects using DDL and DML queries.

CO4: Demonstrate the performance tune of Document-oriented NoSQL database.

CO5: Apply Nosql development tools on different types of NoSQL Database.

Unit-1
Teaching Hours:18
Introduction to Advanced Software Engineering
 

Software reuse-Component-based software engineering-Distributed software engineering Service-oriented architecture- Embedded software-Aspect-oriented software engineering. 

Unit-1
Teaching Hours:18
Lab Exercises
 

1.  Create EER diagram with constraints

2. Populate a table design for the identified domain 

Unit-1
Teaching Hours:18
Introduction to Advanced Databases
 

Using High-Level Conceptual Data Models for Database Design-Naming Conventions, and Design Issues -  Subclasses, Superclasses, and Inheritance-Enhanced Entity Relationship Model-Relational Database Design by EER-to-Relational Mapping-Role of Information Systems in Organizations-Database Design and Implementation Process.

Unit-1
Teaching Hours:18
Introduction to Advanced Software Engineering
 

Software reuse-Component-based software engineering-Distributed software engineering Service-oriented architecture- Embedded software-Aspect-oriented software engineering. 

Unit-1
Teaching Hours:18
Lab Exercises
 

1.  Create EER diagram with constraints

2. Populate a table design for the identified domain 

Unit-1
Teaching Hours:18
Introduction to Advanced Databases
 

Using High-Level Conceptual Data Models for Database Design-Naming Conventions, and Design Issues -  Subclasses, Superclasses, and Inheritance-Enhanced Entity Relationship Model-Relational Database Design by EER-to-Relational Mapping-Role of Information Systems in Organizations-Database Design and Implementation Process.

Unit-1
Teaching Hours:18
Introduction to Advanced Software Engineering
 

Software reuse-Component-based software engineering-Distributed software engineering Service-oriented architecture- Embedded software-Aspect-oriented software engineering. 

Unit-1
Teaching Hours:18
Lab Exercises
 

1.  Create EER diagram with constraints

2. Populate a table design for the identified domain 

Unit-1
Teaching Hours:18
Introduction to Advanced Databases
 

Using High-Level Conceptual Data Models for Database Design-Naming Conventions, and Design Issues -  Subclasses, Superclasses, and Inheritance-Enhanced Entity Relationship Model-Relational Database Design by EER-to-Relational Mapping-Role of Information Systems in Organizations-Database Design and Implementation Process.

Unit-2
Teaching Hours:18
Normalization, File Organization and Indexing
 

Design Guidelines for Relation Schemas - Functional Dependencies - Normal Forms Based on Primary Keys-Second and Third Normal Forms-Boyce-Codd Normal Form - Multivalued Dependency and Fourth Normal Form-Join Dependencies and Fifth Normal Form-Inference Rules, Equivalence and Minimal Cover-Properties of Relational Decompositions - Nulls and Dangling Tuples - File Organization - Organization of Records in Files-Ordered Indices- B+ Tree Index Files - Static Hashing - Bitmap Indices.

Unit-2
Teaching Hours:18
Lab Exercises
 

 3. Database Design using Normalization

4. Design a program for Indexing and performance tuning 

Unit-2
Teaching Hours:18
Software System Modeling
 

Models: Context  – Interaction  - Structural – Behavioural – Model driven engineering – Architectural design decisions -  architectural views – architectural patterns – Application architectures. 

Unit-2
Teaching Hours:18
Normalization, File Organization and Indexing
 

Design Guidelines for Relation Schemas - Functional Dependencies - Normal Forms Based on Primary Keys-Second and Third Normal Forms-Boyce-Codd Normal Form - Multivalued Dependency and Fourth Normal Form-Join Dependencies and Fifth Normal Form-Inference Rules, Equivalence and Minimal Cover-Properties of Relational Decompositions - Nulls and Dangling Tuples - File Organization - Organization of Records in Files-Ordered Indices- B+ Tree Index Files - Static Hashing - Bitmap Indices.

Unit-2
Teaching Hours:18
Lab Exercises
 

 3. Database Design using Normalization

4. Design a program for Indexing and performance tuning 

Unit-2
Teaching Hours:18
Software System Modeling
 

Models: Context  – Interaction  - Structural – Behavioural – Model driven engineering – Architectural design decisions -  architectural views – architectural patterns – Application architectures. 

Unit-2
Teaching Hours:18
Normalization, File Organization and Indexing
 

Design Guidelines for Relation Schemas - Functional Dependencies - Normal Forms Based on Primary Keys-Second and Third Normal Forms-Boyce-Codd Normal Form - Multivalued Dependency and Fourth Normal Form-Join Dependencies and Fifth Normal Form-Inference Rules, Equivalence and Minimal Cover-Properties of Relational Decompositions - Nulls and Dangling Tuples - File Organization - Organization of Records in Files-Ordered Indices- B+ Tree Index Files - Static Hashing - Bitmap Indices.

Unit-2
Teaching Hours:18
Lab Exercises
 

 3. Database Design using Normalization

4. Design a program for Indexing and performance tuning 

Unit-2
Teaching Hours:18
Software System Modeling
 

Models: Context  – Interaction  - Structural – Behavioural – Model driven engineering – Architectural design decisions -  architectural views – architectural patterns – Application architectures. 

Unit-3
Teaching Hours:18
Lab Exercises
 

5. Demonstrate the program for cursors 

6. Compose a program for Procedure/Functions/Packages

Unit-3
Teaching Hours:18
PL/SQL Concepts
 

PL/SQL Block Structure – Identifiers – Literals – Comments - Conditional and Sequential Control - Iterative Processing with Loops - Exception Handlers – Data Retrieval with Cursors - Procedures, Functions, and Parameters – Packages.

Unit-3
Teaching Hours:18
Software Design and Implementation
 

 

Object-oriented design using Unified Modeling Language (UML)-Design Patterns -Test-driven development (TDD)-Code reviews and inspections – Implementation Issues-Coding Standards and Best Practices- Writing Clean Code- Code Reviews- Refactoring Techniques.

Unit-3
Teaching Hours:18
Lab Exercises
 

5. Demonstrate the program for cursors 

6. Compose a program for Procedure/Functions/Packages

Unit-3
Teaching Hours:18
PL/SQL Concepts
 

PL/SQL Block Structure – Identifiers – Literals – Comments - Conditional and Sequential Control - Iterative Processing with Loops - Exception Handlers – Data Retrieval with Cursors - Procedures, Functions, and Parameters – Packages.

Unit-3
Teaching Hours:18
Software Design and Implementation
 

 

Object-oriented design using Unified Modeling Language (UML)-Design Patterns -Test-driven development (TDD)-Code reviews and inspections – Implementation Issues-Coding Standards and Best Practices- Writing Clean Code- Code Reviews- Refactoring Techniques.

Unit-3
Teaching Hours:18
Lab Exercises
 

5. Demonstrate the program for cursors 

6. Compose a program for Procedure/Functions/Packages

Unit-3
Teaching Hours:18
PL/SQL Concepts
 

PL/SQL Block Structure – Identifiers – Literals – Comments - Conditional and Sequential Control - Iterative Processing with Loops - Exception Handlers – Data Retrieval with Cursors - Procedures, Functions, and Parameters – Packages.

Unit-3
Teaching Hours:18
Software Design and Implementation
 

 

Object-oriented design using Unified Modeling Language (UML)-Design Patterns -Test-driven development (TDD)-Code reviews and inspections – Implementation Issues-Coding Standards and Best Practices- Writing Clean Code- Code Reviews- Refactoring Techniques.

Unit-4
Teaching Hours:18
Lab Exercises
 

7. Demonstrate a NoSQL program for basic CRUD operations 

 

8. Design a NoSQL program for type specific queries 

Unit-4
Teaching Hours:18
Software Testing and Security
 

Development Testing – Test-driven development – Release Testing – User testing – Availability and Reliability – Safety – Security Issues.  

Unit-4
Teaching Hours:18
NoSQL Databases
 

Overview of NoSQL Databases-Types of NoSQL databases (document, key-value, graph, column-family)-Use cases for NoSQL databases-MongoDB-Document-oriented database- BSON data format-CRUD operations-Arrays -Type specific queries. 

Unit-4
Teaching Hours:18
Lab Exercises
 

7. Demonstrate a NoSQL program for basic CRUD operations 

 

8. Design a NoSQL program for type specific queries 

Unit-4
Teaching Hours:18
Software Testing and Security
 

Development Testing – Test-driven development – Release Testing – User testing – Availability and Reliability – Safety – Security Issues.  

Unit-4
Teaching Hours:18
NoSQL Databases
 

Overview of NoSQL Databases-Types of NoSQL databases (document, key-value, graph, column-family)-Use cases for NoSQL databases-MongoDB-Document-oriented database- BSON data format-CRUD operations-Arrays -Type specific queries. 

Unit-4
Teaching Hours:18
Lab Exercises
 

7. Demonstrate a NoSQL program for basic CRUD operations 

 

8. Design a NoSQL program for type specific queries 

Unit-4
Teaching Hours:18
Software Testing and Security
 

Development Testing – Test-driven development – Release Testing – User testing – Availability and Reliability – Safety – Security Issues.  

Unit-4
Teaching Hours:18
NoSQL Databases
 

Overview of NoSQL Databases-Types of NoSQL databases (document, key-value, graph, column-family)-Use cases for NoSQL databases-MongoDB-Document-oriented database- BSON data format-CRUD operations-Arrays -Type specific queries. 

Unit-5
Teaching Hours:18
Software Development Methodologies
 

Agile Development-Scrum and Kanban-Agile principles and practices-Iterative and incremental development-DevOps and Continuous Integration-DevOps principles and practices-Continuous integration and continuous deployment (CI/CD)-Version control systems.

Unit-5
Teaching Hours:18
Lab Exercises
 

9. Design a program for Interacting with databases using server-side scripting languages with software testing 

10. Hands-on: Writing and testing code for a small software module

Unit-5
Teaching Hours:18
Database Application Development
 

Web Development and Databases-Integration of databases with web applications-Server-side scripting using Node.js-Mobile App Development and Databases-Database considerations for mobile apps-Extract, Transform, Load (ETL) processes.

Unit-5
Teaching Hours:18
Software Development Methodologies
 

Agile Development-Scrum and Kanban-Agile principles and practices-Iterative and incremental development-DevOps and Continuous Integration-DevOps principles and practices-Continuous integration and continuous deployment (CI/CD)-Version control systems.

Unit-5
Teaching Hours:18
Lab Exercises
 

9. Design a program for Interacting with databases using server-side scripting languages with software testing 

10. Hands-on: Writing and testing code for a small software module

Unit-5
Teaching Hours:18
Database Application Development
 

Web Development and Databases-Integration of databases with web applications-Server-side scripting using Node.js-Mobile App Development and Databases-Database considerations for mobile apps-Extract, Transform, Load (ETL) processes.

Unit-5
Teaching Hours:18
Software Development Methodologies
 

Agile Development-Scrum and Kanban-Agile principles and practices-Iterative and incremental development-DevOps and Continuous Integration-DevOps principles and practices-Continuous integration and continuous deployment (CI/CD)-Version control systems.

Unit-5
Teaching Hours:18
Lab Exercises
 

9. Design a program for Interacting with databases using server-side scripting languages with software testing 

10. Hands-on: Writing and testing code for a small software module

Unit-5
Teaching Hours:18
Database Application Development
 

Web Development and Databases-Integration of databases with web applications-Server-side scripting using Node.js-Mobile App Development and Databases-Database considerations for mobile apps-Extract, Transform, Load (ETL) processes.

Text Books And Reference Books:

[1] Software Engineering A Practitioner‟s Approach, Pressman S Roger McGraw

Hill, International Editions, 7th edition, 2010.

[2] Fundamentals of Database Systems, Elmasri Ramez and Navathe Shamkant B,

Addison-Wesley, 6th Edition, 2010.

[3] Shashank Tiwari,  Professional NoSQL, John Wiley & Sons, Inc, 2011

Essential Reading / Recommended Reading

[1] Software Engineering, Sommerville Ian, Addison-Wesley, 9th Edition, 2011.

[2] Steven Feuerstei, Oracle PL/SQL Programming, O’Reilly, Sixth Edition, 2014.

[3] Sadalage, P. & Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Wiley Publications,1st Edition, 2019.

Evaluation Pattern

CIA - 50%

ESE - 50%

BCA303-4 - INTERNET OF THINGS (2023 Batch)

Total Teaching Hours for Semester:75
No of Lecture Hours/Week:5
Max Marks:100
Credits:4

Course Objectives/Course Description

 

This course is an introduction into the basic concepts and principles of the Internet of Things. It outlines the different protocols for Internet of Things. The challenges and applications of IoT implementations are also discussed in detail in this course. 

Learning Outcome

CO1: Understand the definition and significance of the Internet of Things.

CO2: Demonstrate the ability to understand different protocols and architecture of the Internet of Things.

CO3: Apply the knowledge to interface various sensors with IoT development board.

CO4: Design and implement IoT system for real time applications.

Unit-1
Teaching Hours:15
Introduction to The Internet of Things
 

Introduction – Evolution of IoT ––IoT Definition – Elements of an IoT ecosystem  Roles of Sensors & Actuators – Types of sensors –Working of Sensors  – Development boards –  Arduino – Raspberry pi – Beagle bone – ESP8266 – Interfacing of sensors with development boards – IoT Networking Components – Addressing Strategies in IoT – Trends and implications – Operating System for IoT – Industrial IoT  – IoT applications

Lab Exercises:

  1. Study of Arduino UNO/ /Raspberry pi Board and Components using Tinkercad.
  2. Blinking LED sketch with Arduino UNO/Raspberry pi using Tinkercad.
Unit-1
Teaching Hours:15
Introduction to The Internet of Things
 

Introduction – Evolution of IoT ––IoT Definition – Elements of an IoT ecosystem  Roles of Sensors & Actuators – Types of sensors –Working of Sensors  – Development boards –  Arduino – Raspberry pi – Beagle bone – ESP8266 – Interfacing of sensors with development boards – IoT Networking Components – Addressing Strategies in IoT – Trends and implications – Operating System for IoT – Industrial IoT  – IoT applications

Lab Exercises:

  1. Study of Arduino UNO/ /Raspberry pi Board and Components using Tinkercad.
  2. Blinking LED sketch with Arduino UNO/Raspberry pi using Tinkercad.
Unit-1
Teaching Hours:15
Introduction to The Internet of Things
 

Introduction – Evolution of IoT ––IoT Definition – Elements of an IoT ecosystem  Roles of Sensors & Actuators – Types of sensors –Working of Sensors  – Development boards –  Arduino – Raspberry pi – Beagle bone – ESP8266 – Interfacing of sensors with development boards – IoT Networking Components – Addressing Strategies in IoT – Trends and implications – Operating System for IoT – Industrial IoT  – IoT applications

Lab Exercises:

  1. Study of Arduino UNO/ /Raspberry pi Board and Components using Tinkercad.
  2. Blinking LED sketch with Arduino UNO/Raspberry pi using Tinkercad.
Unit-2
Teaching Hours:15
Sensors and Actuators
 

Introduction – Sensors – Sensor Characteristics – Sensorial Deviations – Sensing Types – Scalar sensing – Multimedia sensing – Hybrid sensing – Virtual sensing – Sensing Considerations – Wearable sensors and their Applications Actuators – Actuator Types – Mechanical actuators – Hydraulic actuators – Thermal or magnetic – Electric actuators – Actuator Characteristics

Lab exercises:

  1. Interfacing of Temperature sensor with Arduino/Raspberry Pi. Write a program to read the specific temperature of a room and display on the serial monitor.
  2. Simulation of 4-Way Traffic Light with Arduino UNO/Raspberry pi
Unit-2
Teaching Hours:15
Sensors and Actuators
 

Introduction – Sensors – Sensor Characteristics – Sensorial Deviations – Sensing Types – Scalar sensing – Multimedia sensing – Hybrid sensing – Virtual sensing – Sensing Considerations – Wearable sensors and their Applications Actuators – Actuator Types – Mechanical actuators – Hydraulic actuators – Thermal or magnetic – Electric actuators – Actuator Characteristics

Lab exercises:

  1. Interfacing of Temperature sensor with Arduino/Raspberry Pi. Write a program to read the specific temperature of a room and display on the serial monitor.
  2. Simulation of 4-Way Traffic Light with Arduino UNO/Raspberry pi
Unit-2
Teaching Hours:15
Sensors and Actuators
 

Introduction – Sensors – Sensor Characteristics – Sensorial Deviations – Sensing Types – Scalar sensing – Multimedia sensing – Hybrid sensing – Virtual sensing – Sensing Considerations – Wearable sensors and their Applications Actuators – Actuator Types – Mechanical actuators – Hydraulic actuators – Thermal or magnetic – Electric actuators – Actuator Characteristics

Lab exercises:

  1. Interfacing of Temperature sensor with Arduino/Raspberry Pi. Write a program to read the specific temperature of a room and display on the serial monitor.
  2. Simulation of 4-Way Traffic Light with Arduino UNO/Raspberry pi
Unit-3
Teaching Hours:15
Architecture and Communication Protocol
 

Layered Architecture for IoT – Protocol Architecture of IoT – IEEE 802.15.4 – Near Field Communication (NFC) – RFID – ZigBee –Bluetooth Low Energy (BLE) – Long Term Evolution-Advanced  – Z-Wave  – Components of ZWave Network – LoRa – NB-IoT – Wi-Fi

Lab exercises:

  1. LED Fade Sketch and Button Sketch 
  2. Analog Input Sketch (Bar Graph with LEDs and Potentiometer) 
Unit-3
Teaching Hours:15
Architecture and Communication Protocol
 

Layered Architecture for IoT – Protocol Architecture of IoT – IEEE 802.15.4 – Near Field Communication (NFC) – RFID – ZigBee –Bluetooth Low Energy (BLE) – Long Term Evolution-Advanced  – Z-Wave  – Components of ZWave Network – LoRa – NB-IoT – Wi-Fi

Lab exercises:

  1. LED Fade Sketch and Button Sketch 
  2. Analog Input Sketch (Bar Graph with LEDs and Potentiometer) 
Unit-3
Teaching Hours:15
Architecture and Communication Protocol
 

Layered Architecture for IoT – Protocol Architecture of IoT – IEEE 802.15.4 – Near Field Communication (NFC) – RFID – ZigBee –Bluetooth Low Energy (BLE) – Long Term Evolution-Advanced  – Z-Wave  – Components of ZWave Network – LoRa – NB-IoT – Wi-Fi

Lab exercises:

  1. LED Fade Sketch and Button Sketch 
  2. Analog Input Sketch (Bar Graph with LEDs and Potentiometer) 
Unit-4
Teaching Hours:15
IoT Communication Technologies
 

Introduction – Constrained nodes – Constrained networks – Types of constrained devices – Low power and lossy networks – Infrastructure Protocols – Internet protocol version 6 (IPv6) – RPL – IPv6 over Low Power Wireless Personal Area Networks (6LoWPAN) – Micro internet protocol (uIP) – Nano internet protocol (nanoIP) – Discovery Protocols – Data Protocols – MQTT – CoAP –   REST – Identification Protocols – Device Management – Semantic Protocols 

Lab exercises:

  1. Digital Read Serial Sketch (Working with Motion/IR/Gas or Any other Sensor)
  2. Spinning a DC Motor and Motor Speed Control Sketch 
Unit-4
Teaching Hours:15
IoT Communication Technologies
 

Introduction – Constrained nodes – Constrained networks – Types of constrained devices – Low power and lossy networks – Infrastructure Protocols – Internet protocol version 6 (IPv6) – RPL – IPv6 over Low Power Wireless Personal Area Networks (6LoWPAN) – Micro internet protocol (uIP) – Nano internet protocol (nanoIP) – Discovery Protocols – Data Protocols – MQTT – CoAP –   REST – Identification Protocols – Device Management – Semantic Protocols 

Lab exercises:

  1. Digital Read Serial Sketch (Working with Motion/IR/Gas or Any other Sensor)
  2. Spinning a DC Motor and Motor Speed Control Sketch 
Unit-4
Teaching Hours:15
IoT Communication Technologies
 

Introduction – Constrained nodes – Constrained networks – Types of constrained devices – Low power and lossy networks – Infrastructure Protocols – Internet protocol version 6 (IPv6) – RPL – IPv6 over Low Power Wireless Personal Area Networks (6LoWPAN) – Micro internet protocol (uIP) – Nano internet protocol (nanoIP) – Discovery Protocols – Data Protocols – MQTT – CoAP –   REST – Identification Protocols – Device Management – Semantic Protocols 

Lab exercises:

  1. Digital Read Serial Sketch (Working with Motion/IR/Gas or Any other Sensor)
  2. Spinning a DC Motor and Motor Speed Control Sketch 
Unit-5
Teaching Hours:15
IoT Challenges
 

IoT Security Threats – IoT Security Requirements –Privacy in IoT Networks – Reliability Challenges – Interoperability of Devices – Reliability Issues Due to Energy Constraint – Cloud Platforms for IoT – Virtualization concepts and Cloud Architecture – Cloud computing –  Study of IoT Cloud platforms  – ThingSpeak API and MQTT – Interfacing ESP8266 with Web services

Lab exercises:

  1. Interfacing Arduino UNO/Raspberry pi with Cloud (Thingspeak API)
  2. Write a program to visualize data of temperature sensor on Arduino IoT cloud/Thingspeak
Unit-5
Teaching Hours:15
IoT Challenges
 

IoT Security Threats – IoT Security Requirements –Privacy in IoT Networks – Reliability Challenges – Interoperability of Devices – Reliability Issues Due to Energy Constraint – Cloud Platforms for IoT – Virtualization concepts and Cloud Architecture – Cloud computing –  Study of IoT Cloud platforms  – ThingSpeak API and MQTT – Interfacing ESP8266 with Web services

Lab exercises:

  1. Interfacing Arduino UNO/Raspberry pi with Cloud (Thingspeak API)
  2. Write a program to visualize data of temperature sensor on Arduino IoT cloud/Thingspeak
Unit-5
Teaching Hours:15
IoT Challenges
 

IoT Security Threats – IoT Security Requirements –Privacy in IoT Networks – Reliability Challenges – Interoperability of Devices – Reliability Issues Due to Energy Constraint – Cloud Platforms for IoT – Virtualization concepts and Cloud Architecture – Cloud computing –  Study of IoT Cloud platforms  – ThingSpeak API and MQTT – Interfacing ESP8266 with Web services

Lab exercises:

  1. Interfacing Arduino UNO/Raspberry pi with Cloud (Thingspeak API)
  2. Write a program to visualize data of temperature sensor on Arduino IoT cloud/Thingspeak
Text Books And Reference Books:
  1. Introduction to IoT, Sudip Misra, Anandarup Mukherjee, Arijit Roy (Cambridge University Press) 2021
  2. Internet of Things: Principles and Paradigms, R. Buyya and A.K. Dastjerdi (Elsevier) 2016.
  3. Internet of Things: A Hands-on Approach, Arshdeep Bahga and Vijay Madisetti, 2016 (Universities Press)
Essential Reading / Recommended Reading
  1. The Internet of Things: Enabling Technologies, Platforms, and Use Cases, Pethuru Raj and Anupama C. Raman,2017 (CRC Press)
  2. Internet of Things-Architectures, Protocols and Standards,Simone Cirani, Gianluigi Ferrari, Marco Picone, Luca Veltri, Wiley,2018
  3. Internet of Things- Architecture and Design Principles, Raj Kamal, McGraw Hill Education,2017
Evaluation Pattern

CIA 50%

ESE 50%

BCA304-4 - ADVANCED JAVA (2023 Batch)

Total Teaching Hours for Semester:90
No of Lecture Hours/Week:6
Max Marks:100
Credits:4

Course Objectives/Course Description

 

This course will help the learners to gain sound knowledge of object-oriented principles,GUI application design with database, enterprise application design with Servlets.

Learning Outcome

CO1: Demonstrate and Understand the principles of object-oriented programming in constructing robust, maintainable programs.

CO2: Analyze the various societal and environmental problems critically to develop solutions using the features of programming language.

CO3: Design the solutions to the challenging requirements of enterprise applications.

CO4: Build competence in Java programming to develop small-to-medium-sized applications with professionally acceptable coding and performance standards.

Unit-1
Teaching Hours:18
FUNDAMENTALS OF JAVA
 

Review of Core Java: Class Object, Object Oriented Concepts for Java, Interfaces, Packages, and Exception Handling.

Unit-1
Teaching Hours:18
Lab Exercises:
 

1. Identify a domain of your choice and list ten entities. For each entity, identify a minimum of ten attributes and assign the data type for each attribute with proper justification.

2. Implement the concept of package and interface.

3.Implement multithreading – Thread class, Runnable interface, thread synchronization, and thread communication

Unit-1
Teaching Hours:18
MULTITHREADING IN JAVA
 

Thread Model - Life cycle of a Thread - Java Thread Priorities - Runnable interface and Thread Class- Thread Synchronization -Dead Lock– Inter Thread Communication.

Unit-1
Teaching Hours:18
FUNDAMENTALS OF JAVA
 

Review of Core Java: Class Object, Object Oriented Concepts for Java, Interfaces, Packages, and Exception Handling.

Unit-1
Teaching Hours:18
Lab Exercises:
 

1. Identify a domain of your choice and list ten entities. For each entity, identify a minimum of ten attributes and assign the data type for each attribute with proper justification.

2. Implement the concept of package and interface.

3.Implement multithreading – Thread class, Runnable interface, thread synchronization, and thread communication

Unit-1
Teaching Hours:18
MULTITHREADING IN JAVA
 

Thread Model - Life cycle of a Thread - Java Thread Priorities - Runnable interface and Thread Class- Thread Synchronization -Dead Lock– Inter Thread Communication.

Unit-1
Teaching Hours:18
FUNDAMENTALS OF JAVA
 

Review of Core Java: Class Object, Object Oriented Concepts for Java, Interfaces, Packages, and Exception Handling.

Unit-1
Teaching Hours:18
Lab Exercises:
 

1. Identify a domain of your choice and list ten entities. For each entity, identify a minimum of ten attributes and assign the data type for each attribute with proper justification.

2. Implement the concept of package and interface.

3.Implement multithreading – Thread class, Runnable interface, thread synchronization, and thread communication

Unit-1
Teaching Hours:18
MULTITHREADING IN JAVA
 

Thread Model - Life cycle of a Thread - Java Thread Priorities - Runnable interface and Thread Class- Thread Synchronization -Dead Lock– Inter Thread Communication.

Unit-2
Teaching Hours:18
Lab Exercises:
 

4. Implement the concept of Generics.

5. Implement the concept of Lambda Expression.

Unit-2
Teaching Hours:18
GENERICS, LAMBDA AND STREAM FRAMEWORK
 

Generics 

Generics Concept - General Form of a Generic Class – Bounded Types – Generic Class Hierarchy - Generic Interfaces – Restrictions in Generics.

Unit-2
Teaching Hours:18
LAMBDA EXPRESSION
 

Introduction to Lambda expression- Block Lambda Expressions - Generic Functional Interfaces.

Unit-2
Teaching Hours:18
STREAMS
 

Introduction to streams in Java – Creation of Streams – Different operations on streams.

Unit-2
Teaching Hours:18
Lab Exercises:
 

4. Implement the concept of Generics.

5. Implement the concept of Lambda Expression.

Unit-2
Teaching Hours:18
GENERICS, LAMBDA AND STREAM FRAMEWORK
 

Generics 

Generics Concept - General Form of a Generic Class – Bounded Types – Generic Class Hierarchy - Generic Interfaces – Restrictions in Generics.

Unit-2
Teaching Hours:18
LAMBDA EXPRESSION
 

Introduction to Lambda expression- Block Lambda Expressions - Generic Functional Interfaces.

Unit-2
Teaching Hours:18
STREAMS
 

Introduction to streams in Java – Creation of Streams – Different operations on streams.

Unit-2
Teaching Hours:18
Lab Exercises:
 

4. Implement the concept of Generics.

5. Implement the concept of Lambda Expression.

Unit-2
Teaching Hours:18
GENERICS, LAMBDA AND STREAM FRAMEWORK
 

Generics 

Generics Concept - General Form of a Generic Class – Bounded Types – Generic Class Hierarchy - Generic Interfaces – Restrictions in Generics.

Unit-2
Teaching Hours:18
LAMBDA EXPRESSION
 

Introduction to Lambda expression- Block Lambda Expressions - Generic Functional Interfaces.

Unit-2
Teaching Hours:18
STREAMS
 

Introduction to streams in Java – Creation of Streams – Different operations on streams.

Unit-3
Teaching Hours:18
Lab Exercises:
 

6. Implement the concept of JDBC.

7. Write a JAVA Program to perform join on two tables.

Unit-3
Teaching Hours:18
JAVA DATABASE CONNECTIVITY
 

Java Database Connectivity (JDBC): Introduction, JDBC Drivers, JDBC Architecture, JDBC Classes and Interfaces, loading a Driver, making a Connection, Execute SQL Statement, SQL Statements, Retrieving Results, Getting Database Information, Scrollable and Updatable Result set, Result Set Metadata.

Unit-3
Teaching Hours:18
Lab Exercises:
 

6. Implement the concept of JDBC.

7. Write a JAVA Program to perform join on two tables.

Unit-3
Teaching Hours:18
JAVA DATABASE CONNECTIVITY
 

Java Database Connectivity (JDBC): Introduction, JDBC Drivers, JDBC Architecture, JDBC Classes and Interfaces, loading a Driver, making a Connection, Execute SQL Statement, SQL Statements, Retrieving Results, Getting Database Information, Scrollable and Updatable Result set, Result Set Metadata.

Unit-3
Teaching Hours:18
Lab Exercises:
 

6. Implement the concept of JDBC.

7. Write a JAVA Program to perform join on two tables.

Unit-3
Teaching Hours:18
JAVA DATABASE CONNECTIVITY
 

Java Database Connectivity (JDBC): Introduction, JDBC Drivers, JDBC Architecture, JDBC Classes and Interfaces, loading a Driver, making a Connection, Execute SQL Statement, SQL Statements, Retrieving Results, Getting Database Information, Scrollable and Updatable Result set, Result Set Metadata.

Unit-4
Teaching Hours:18
NETWORK PROGRAMMING & APPLICATIONS IN DISTRIBUTED ENVIRONMENT
 

Introduction to Client-server concepts, socket programming, and Client and Server-side programming. Remote Method Invocation (RMI): Introduction, Remote Method Invocation, Java RMI Interfaces and Classes, an Application, Compiling the Program, Generating Stub Classes, Running the Program, Callback with an Application.

Unit-4
Teaching Hours:18
Lab Exercises:
 

8.Write a Java program to create a simple TCP server, accept a client connection, and exchange messages.

 9.Create a simple "Hello, world!" RMI program with a remote interface, an implementation class, a server, and a client.

Unit-4
Teaching Hours:18
NETWORK PROGRAMMING & APPLICATIONS IN DISTRIBUTED ENVIRONMENT
 

Introduction to Client-server concepts, socket programming, and Client and Server-side programming. Remote Method Invocation (RMI): Introduction, Remote Method Invocation, Java RMI Interfaces and Classes, an Application, Compiling the Program, Generating Stub Classes, Running the Program, Callback with an Application.

Unit-4
Teaching Hours:18
Lab Exercises:
 

8.Write a Java program to create a simple TCP server, accept a client connection, and exchange messages.

 9.Create a simple "Hello, world!" RMI program with a remote interface, an implementation class, a server, and a client.

Unit-4
Teaching Hours:18
NETWORK PROGRAMMING & APPLICATIONS IN DISTRIBUTED ENVIRONMENT
 

Introduction to Client-server concepts, socket programming, and Client and Server-side programming. Remote Method Invocation (RMI): Introduction, Remote Method Invocation, Java RMI Interfaces and Classes, an Application, Compiling the Program, Generating Stub Classes, Running the Program, Callback with an Application.

Unit-4
Teaching Hours:18
Lab Exercises:
 

8.Write a Java program to create a simple TCP server, accept a client connection, and exchange messages.

 9.Create a simple "Hello, world!" RMI program with a remote interface, an implementation class, a server, and a client.

Unit-5
Teaching Hours:18
Lab Exercises:
 

10. write a JSP program to display a message.

11. Implement the Concept of Java Beans.

Unit-5
Teaching Hours:18
SPRING
 

Introduction to Spring – Spring Modules and Applications.

Unit-5
Teaching Hours:18
ENTERPRISE APPLICATIONS AND SPRING
 

Overview of J2EE, Introduction to JavaBeans, Advantages of JavaBeans, Properties of JavaBeans with examples, JavaBeans API, Enterprise JavaBeans (EJB), Applications using Session Beans and Entity Beans.

Unit-5
Teaching Hours:18
Lab Exercises:
 

10. write a JSP program to display a message.

11. Implement the Concept of Java Beans.

Unit-5
Teaching Hours:18
SPRING
 

Introduction to Spring – Spring Modules and Applications.

Unit-5
Teaching Hours:18
ENTERPRISE APPLICATIONS AND SPRING
 

Overview of J2EE, Introduction to JavaBeans, Advantages of JavaBeans, Properties of JavaBeans with examples, JavaBeans API, Enterprise JavaBeans (EJB), Applications using Session Beans and Entity Beans.

Unit-5
Teaching Hours:18
Lab Exercises:
 

10. write a JSP program to display a message.

11. Implement the Concept of Java Beans.

Unit-5
Teaching Hours:18
SPRING
 

Introduction to Spring – Spring Modules and Applications.

Unit-5
Teaching Hours:18
ENTERPRISE APPLICATIONS AND SPRING
 

Overview of J2EE, Introduction to JavaBeans, Advantages of JavaBeans, Properties of JavaBeans with examples, JavaBeans API, Enterprise JavaBeans (EJB), Applications using Session Beans and Entity Beans.

Text Books And Reference Books:
  1. Herbert Schildt, Java: The Complete Reference, Oracle Press, Twelfth Edition, 2022 
  2. Java ™ A Beginner’s Guide, Herbert Schildt, McGraw-Hill Education, 8th Edition, 2021 
  3. Tom Valesky, “Enterprise JavaBeans – Developing component-based Distributed Applications,” Pearson 2000. 
Essential Reading / Recommended Reading
  1. Kathy Sierra, Bert Bates, Trisha Gee,Head First Java, 3rd Edition,2022.
  2. Cay S. Horstmann, Core Java Volume-1 Fundamentals, 11th edition, 2018, Pearson Education.
  3. The complete reference JSP 2.0, Tata McGraw-Hill, 2nd Edition, Phil Hanna,2017.

 

Evaluation Pattern

ESE 50%

CIA 50%